Recent content by dexeloper

Tell me Philhege did you know that you can set up a linked server in SQL Server to Indexing Services and then query documents within tsql?

Has anyone set up a Linked Server to Windows Search Services. I'm struggling to find the necessary parameters. Many thanks.

Hmm. Food for thought indeed. Many thanks.

I've written a system in the past that searched the contents of tables and the content of external documents. This was done by using Indexing Services over the documents, creating a linked server in SQL with provider 'MSIDXS', and using an openquery statement in SQL to search the contents. If I...

MakeItSo you're a bloody star. One in a million. Everything they say about you is lies. The crate of ale is in the post and the lobster sandwiches will follow shortly. I WILL have a good weekend. Thanks again.

The 'insert' instruction appears fine.

What I've shown is just a cutdown of a much bigger script. The point, I think, is that the 'read' brings in the Chinese fine but the 'write' doesn't. If I run an 'insert select' in SQLServer query analyser it works fine.

I have a WSH vbscript that reads one SQLServer table and writes to another. Just one nvarchar column per table. Some of the 'from' data is in Chinese and a wscript.echo shows the Chinese values fine. However, when I write to the second table Chinese characters come out as '???????'. This is...

Agreed feherke. I wasn't using '.test'. This works: var reInt = /^\d+$/; if (!reInt.test(document.getElementById("xx").value)){alert("error");} Many thanks

I can see I made a fopa with the value being checked. However even this gives the same error: var reInt = /^\d+$/; if (!reInt("gg")){alert("error");} Something about regular expressions, objects and functions ...

These two lines ... var reInt = /^\d+$/; if (!reInt(document.getElementById("xx"))){alert("error");} ... work fine in Firefox but in Chrome give me 'object is not a function' for the second line. I don't think anything else is relevant. Just trying to test the input is integer. Any ideas?

You're saying vodafone will charge the receiving (mobile) account?

I've tried all variants of my mobile number. I've done it by sending an email from my hotmail account. But I always get 'failed delivery status'.

I can send emails via the CDO object. It's free. I want to do the same with text messages to mobiles (sms). I've googled and read umpteen websites. Personally I'm with vodafone in the UK. Various sites say send an email to telno@vodafone.net and it will appear as a message on my phone. It...

I suspect your trying to pass two values, from the Signed table, to the 'signed.asp' page. This should do it: if rs("lastqst")="Yes" then response.redirect("signed.asp?cycle=" & rs1("cycle") & "&function=" & rs1("function")) end if