Search:

Hi,

I realise that this is a very old thread but I've had a very similar problem and wanted to add my solution since one hasn't been provided yet -

If you have "Text Interpretation" set to HTML...

Hi,

I believe that I've fixed this by changing the default serializer. From .Net Framwork 3.0 microsoft changed the default serializer to the DataContract serializer, which is different from the...

Hi,

I have a WCF web service targeting .Net Framework 4 which utilizes a serialization class generated from a xsd schema using xsd.exe.

When I request the xsd from the service...

Hi,

I've managed to fix this by regenerating my class (xsd.exe) using the f switch "/f[ields]" which generates fields instead of properties. By default, properties are generated.

...

Hi,

I've created a WCF web service and generated the xml serialization class with xsd.exe. My problem is that when I request the xsd from the service...

Hi,

I realise that this a very old thread. I recently upgraded to windows 7 64bit and no longer have vb6 installed, I've just been on the forum and tried to use the highlight option on the vbforum...

Hi,

Thanks for your reply

My understanding is that the attribute tag defined within an element will make it an attribute of the parent element.

http://www.w3schools.com/xsl/el_attribute.asp...

Hi,

I'm trying to write a service but there seems to be something not working with my set up. I've generated the .Net serialization classes from my xsd using xsd.exe, so far so good. When I query...

Hi,

Eureka, I've figured it out.

I changed my development environment from web developer to general and the missing options have magically appeared.


Tools -> Import and Export...

Jmcilhinney,

Hi and thanks for your reply.

I'm using visual studio 2010 pro. when I do as you suggest the toolbox and start page options are not displayed under the standard toolbar. See the...

Hi,

I read somewhere that there is a toolbar that contains an item to access the "Start Page" instead of clicking View --> Start Page. I've hunted through the toolbars and can't find it. Does...

TechGnome,

You might have cracked it; I've changed the "like" to "=" and the error has gone away. With SQL2005 or perhaps it was 2000, I was told to use "LIKE" instead of "=" when comparing large...

TechGnome,

Thanks for your reply, I've quadripple checked it and it's a nvarchar(max)


Body nvarchar(max),

As a temporary workaround I'm ignoring the changed check if the...

Hi Si,

Thanks for your reply I've tried your suggestion but no luck, I've done a little more testing and it seems that it's not IsNull, I've changed the line to -


AND Body LIKE @Body

the...

Hi,

I have a stored procedure that checks to see if the passed through data has changed before actually updating the table this works perfectly until the data exceeds 4000 characters despite the...

Si,

Thanks your pointer helped, I changed my variable declaration from -


DECLARE @Mtg_Id int
To

DECLARE @Mtg_Id numeric(18,0)
it's performing much better now.

I've been doing some more testing on this and I've made the following discovery. When I hard code the value of @Mtg_Id the query returns super quick if I use the variable is takes ages?

Very slow...

Hi,

I'm having performance problems with a query on a table with loads of nulls in a particular column. I've tried changing the nulls to 0 (Zero) and rebuilt the index on the column but it's not...

Honeybee,

Thanks, I've had a quick look I've not been able to find what I'm looking for please forgive me if it's there and I'm not seeing it.

Here is a link to my post in General PC

This...

Dilettant; I'm going to have a hunt around for a technet forum to join for any future command line conundrums.

HoneyBee; I searched on google first but didn't find what I was looking for, which is...

Hack,

Snap you suggested pretty much what I've managed to figure out. I must have started typing out my reply just before you posted yours.

Many thanks

Cheers Al

As a workaround I've applied the following which works but I was hoping for a cleaner solution.



SET counter=0
FOR /r "e:\test\myfiles\" %%X IN (*.jpg) DO (set /a counter+=1)
FOR /r...

Hi,

I'm not sure if this is the best place to post this question so please forgive me if it's not.

I've got a for loop in a batch file that loops ".jpg" files and I'd like to change it to find...

Hi,

Thanks for all your replies.

Yes I'm talking about batch files .bat or .cmd

TheBigB: Thanks I'll try posting it there.

Cheers Al

Hi,

I have a question about using a For Loop in a cmd file can anyone advise me which forum would be best to post it in?

Cheers Al

BaileyPhil,

You call it like this -

Dim sMyLCName: sMyLCName="o'connor"
Dim sMyPCName: sMyPCName=""

' ProperCase(sText)
sMyPCName=ProperCase(sMyLCName)

Stanav,

Thanks for the pointer.

I've logged into the server and run it as you suggested but it's not executing. Password is okay because I deliberately put in an incorrect password and it...

Thanks for your replies

Stanav; Nice idea, do you know how to access the RunAs command, I'm using a win 2003 server for this. The secondary logon service is running but when I right click or shift...

Hi,

I'm trying to execute a cmd file with a different user but what I have isn't working the log in returns true but the command doesn't run


Dim iu As New ImpersonateUser
' Note: This user...

Think I've got it, however it's not going to work for me because newlines are replaced with slashes "/". I can't be sure that if I replace the slashes in my SP with newlines that I won't removing...

Hi,

I'd like to use SQLCMD to update my database. I've created a SP and am now trying to figure out how to supply one of the parameters as a variable/contents of a file, is this possible?

I'm...

Samba,

Thanks for your reply, yes I guess that's an option but I was looking for something a little more bullet proof.

An option might be to surround any fields that might contain non-standard...

Hi,

I'm trying to write/find a regular expression for finding ampersands but not HTML entites

I have this which finds entities but can't quite figure out how to ignore entities and return...

Perfect thanks

Hi,

I need to set up full text searching on a table with a non-numeric composite primary key. When I try to do this I get an error saying it requires a unique index, despite the fact that the...

KevChadders and NeedSomeAnswers,

Thanks for your replies, both helped me come up with a solution: Use a derived table -


SELECT b.Browser, b.Browser_Major_Ver, COUNT(*) AS Usage_Count
FROM (...

NeedSomeAnswers,

Thanks for your reply, unfortunately that returns the user id in the results which I don't want

Hi,

I'm trying to write a query to get the browser usage stats on my site. I know that these are very difficult to get right but I'm looking for the best that I can have based on the information...

I think I've cracked it, or lets say that it's performing okay against the variations that I've tried it with.

I've added a word boundary to the end of the tag list see hilighted -


Dim sPat :...

Mendhak,

Thanks for your reply. Wouldn't that eliminate all tags like <b> and or all closing tags?

Is this what you meant?

Dim sPat : sPat = "</?(" & sTags & ")\s+(.|\n)*?>"

Al