Comments by pkfox (Top 195 by date)

Thanks Sandeep I would like to be able to change the startup page without modifying the source code if possible.

Are you mentally retarded ?

Thanks Richard as you know all this Web stuff makes me glaze over :-) I need to find a way of capturing the notification outside of a form

I think the problem is, the page is refreshed after the script runs so the DOM is being overwritten

Thanks Richard have you any idea on my other ( related ) question ?

Hi thanks for your reply , If it was a CORS problem the c# code wouldn't work either and it does

Hi and thanks for your thoughts, there are no setTimeout() calls and certainly no SignalR method - this is a hobby project and pretty basic

I have Dave but it doesn't explain how I subscribe to a server

Ok thanks Dave

if a large part of your code is already done put it on here

Probably not the problem but try
request.Headers.Add("Authorization:", "Bearer " + AccessToken);
Notice the : after Authorization

I'm not one of them I live in the debugger but I am found wanting debugging Web stuff.

Thanks Graeme much appreciated

With respect Graeme I've been programming professionaly for ~ 50 years

I've tried some of those suggestions Graeme but none of them work - no errors just don't work

Now you have your data in a database you can do what you like with it - what is the problem ?

OG made it very clear, if you need to modify your data USE A DATABASE

Thanks Richard

Thanks Bob how can I call that code ( I've never used JavaScript ) from my page ?

Hi Richard , I agree it is a mess but I don't know how to add things to the original question

If I set all the vars from the command line and run this

curl -s -d "grant_type=client_credentials&client_id=%CLIENTID%&client_secret=%CLIENTSECRET%&resource=%RESOURCE%" %AZURESITE%|jq .access_token

it works ( notice I've removed the ^ escape character ) but it still errors out in the batch file.

The beautiful output



<title>Sign in to your account























//<![CDATA[
$Config={"iErrorDesc":0,"iErrorTitle":0,"strMainMessage":"We received a bad request.","strAdditionalMessage":"","strServiceExceptionMessage":"AADSTS900561: The endpoint only accepts POST, OPTIONS requests. Received a GET request.","strTraceId":"cb3a6f0d-d5fc-41f8-9c9b-94690b911800","iErrorCode":900561,"iHttpErrorCode":400,"iViewId":1,"urlCancel":"","strTimestamp":"2022-11-01T09:14:55Z","urlLearnMoreRiskyApp":"https://go.microsoft.com/fwlink/?linkid=2133457","oResumePostParams":{},"iMaxStackForKnockoutAsyncComponents":10000,"fShowButtons":true,"urlCdn":"https://aadcdn.msauth.net/shared/1.0/","urlDefaultFavicon":"https://aadcdn.msauth.net/shared/1.0/content/images/favicon_a_eupayfgghqiai7k9sol6lg2.ico","urlFooterTOU":"https://www.microsoft.com/en-US/servicesagreement/","urlFooterPrivacy":"https://privacy.microsoft.com/en-US/privacystatement","iPawnIcon":0,"sPOST_Username":"","sFTName":"flowToken","fEnableOneDSClientTelemetry":true,"urlReportPageLoad":"https://login.microsoftonline.com/common/instrumentation/reportpageload?mkt=en-US","dynamicTenantBranding":null,"staticTenantBranding":null,"oAppCobranding":{},"iBackgroundImage":2,"fApplicationInsightsEnabled":false,"iApplicationInsightsEnabledPercentage":0,"urlSetDebugMode":"https://login.microsoftonline.com/common/debugmode","fEnableCssAnimation":true,"fAllowGrayOutLightBox":true,"fIsRemoteNGCSupported":true,"fUseSameSite":true,"uiflavor":1001,"fOfflineAccountVisible":false,"fEnableUserStateFix":true,"fShowAccessPassPeek":true,"fUpdateSessionPollingLogic":true,"fUseNewAuthenticatorIcon":true,"fDetectMultiHighContrastThemes":true,"fFetchSessionsSkipDsso":true,"scid":1013,"hpgact":1801,"hpgid":1117,"pgid":"ConvergedError","apiCanary":"AQABAAAAAAD--DLA3VO7QrddgJg7Wevrs7KbdxKpBUOZhqjuYy6kGKqs7mpv6-VNSTes4n1KrZgZefUVcE62EYPgzicVelouJU6Ul_KwO-j-PPs30JzkTtlEWLSq8SpLZZfRwGinOOqSm7thwpfhj3Rq1qLyxXZ_f3j5SpqIyefj_Xe15pilotFhyvPxuN7ogqXUcyPhQ4LlwHef7OdL7hsfPGaWjzfrdFGkAdZlyr7uYpybAzK8BiAA","canary":"RZupQpVcS6yQ8XeRmjAKH9MSZlIQ1SsAUv7ZA7fizEo=7:1","correlationId":"13d5c048-43b5-4513-8361-33d075635bb9","sessionId":"cb3a6f0d-d5fc-41f8-9c9b-94690b911800","locale":{"mkt":"en-US","lcid":1033},"slMaxRetry":2,"slReportFailure":true,"strings":{"desktopsso":{"authenticatingmessage":"Trying to sign you in"}},"enums":{"ClientMetricsModes":{"None":0,"SubmitOnPost":1,"SubmitOnRedirect":2,"InstrumentPlt":4}},"urls":{"instr":{"pageload":"https://login.microsoftonline.com/common/instrumentation/reportpageload","dssostatus":"https://login.microsoftonline.com/common/instrumentation/dssostatus"}},"browser":{"ltr":1,"_Other":1,"Full":1,"RE_Other":1,"b":{"name":"Other","major":-1,"minor":-1},"os":{"name":"Unknown","version":""},"V":-1},"watson":{"url":"/common/handlers/watson","bundle":"https://aadcdn.msauth.net/ests/2.1/content/cdnbundles/watson.min_q5ptmu8aniymd4ftuqdkda2.js","sbundle":"https://aadcdn.msauth.net/ests/2.1/content/cdnbundles/watsonsupportwithjquery.3.5.min_dc940oomzau4rsu8qesnvg2.js","fbundle":"https://aadcdn.msauth.net/ests/2.1/content/cdnbundles/frameworksupport.min_oadrnc13magb009k4d20lg2.js","resetErrorPeriod":5,"maxCorsErrors":-1,"maxInjectErrors":5,"maxErrors":10,"maxTotalErrors":3,"expSrcs":["https://login.microsoftonline.com","https://aadcdn.msauth.net/","https://aadcdn.msftauth.net/",".login.microsoftonline.com"],"envErrorRedirect":true,"envErrorUrl":"/common/handlers/enverror"},"loader":{"cdnRoots":["https://aadcdn.msauth.net/","https://aadcdn.msftauth.net/"],"logByThrowing":true},"serverDetails":{"slc":"ProdSlices","dc":"NEULR1","ri":"DB5XXXX","ver":{"v":[2,1,14006,10]},"rt":"2022-11-01T09:14:55","et":0},"clientEvents":{"enabled":true,"telemetryEnabled":true,"useOneDSEventApi":true,"flush":60000,"autoPost":true,"autoPostDelay":1000,"minEvents":1,"maxEvents":1,"pltDelay":500,"

Hi Bill, thanks for replying - there is no reference to it in the .csproj file, but it is shown under Dependencies\Microsoft.NETCore.App which points to a physical file in C:\Program Files\dotnet\packs\Microsoft.NETCore.App.Ref\6.0.1\ref\net6.0\System.Runtime.dll - but that file is dated 23/11/2021

That did it thanks Richard

Thanks for all your help Peter I do appreciate it, I don't have any custom CSS in the mix just the usual bootstrap.css. It's definitely fixed-top that stretches the navbar though.

Hi Peter, same result the navbar goes the full screen width and the content is centred.

Hi Richard I had to add this to the csproj file - all is good now

<PropertyGroup>    <PreserveCompilationContext>true</PreserveCompilationContext>    <MvcRazorCompileOnPublish>false</MvcRazorCompileOnPublish>    <CopyRazorGenerateFilesToPublishDirectory>true</CopyRazorGenerateFilesToPublishDirectory>  </PropertyGroup>

Thanks Richard I'll check - the site is published by a Jenkins pipeline script which uses the dotnet publish command, I'll see if there's a flag to set this

I notice you are 5 points ahead of OG for the last 24hrs

HI Richard, I tried the type=date and it does pop up a date picker but type=time only gives me two input areas no pop up picker - is this expected ?

Ok thanks Richard I'm only using this in a personal project - I'm sure you realise I'm not a Web dev :-)

I have it working now Richard - there were some vars declared in the top of the script which conflicted with mine - slaps forehead - thanks for all your help - learnt a few things today - need beer.

No fun in that Richard :-)

What are the double minuses for ?

As the div contains a local image Richard I don't think I can use JSFiddle

It's not bad on my box - this works

$('#hour')[0].style[prop] = 'rotate(' + hourAngle + 'deg)';

This dosen't

var hour = document.getElementById('hour');
hour.style[prop] = 'rotate(' + hourAngle + 'deg)';

The div has an image as shown

<div id="hour"><img src="~/paulrhayes.com-experiments-master/clock/images/hourHand.png" /></div>

How do I do that Richard ?

Thanks Richard

I don't know what it is I'm doing wrong Richard - there seems to be some confusion between commenting and solutions - hopefully this is a comment and therefore allowed

Thanks Patrice

I've got that Paul thanks

Thanks Richard that does the trick

Hi Pete, just a heads up - on your recommendation I installed BaGet on a Linux box and it works beautifully , it was the last part of the jigsaw to my automating my deployment process - one thing I had to do to get it building with Jenkins was to create a nuget.config file and add the url of the BaGet server and I was away. Thanks very much for your advice.

Hi Pete have you setup a nuget repository on Linux ?

Success !!! albeit in a not pretty fashion - I created a new Jenkins pipeline item which pulls the two repos in ( you can't do what you sugested into the same folder as it gets overwritten by the second ) then build the common repo first followed by the second ( here comes the orrible bit ) the caveat is I had to put

/home/pjk/Jenkins/Linux-ARM64/Common/Common.dll

in the Consumer.csproj file in github as a ItemGroup Reference - I perform a dotnet build in the script which outputs Common.dll to this folder - it's a start though - thoughts ?

That's food for thought Pete thanks - I've used Jenkins to build and publish nuget packages before ( that was on Windows though ) my current need is net core on Linux ARM64

Hi Sander,I'm such a fool ( replying to myself ) what you suggest is roughly what I had in mind. In my current state I'm just trying to get a successful build with two projects let's call them EntityConsumer and Entities, if I read you correctly you are saying build Entities and then trigger a build of EntityConsumer which has a dependency on Entities ? ( what could possibly go wrong :-) ? ) I'll give it a go - thanks very much for your help and patience

Hi Bill, thanks for the compliment - most of the jenkins link I've found are IRC rooms - not keen on them

How could I do that Sander ?

Thanks Jochen I'll give it a try

I know I know :-)

Thanks Jochen

Thanks Paul, the whole program will be rewritten very soon ( it was written in 2001 ) in C# , the change I've got to make is a path to the output file so should be ok , I agree ( goto ) I've never used a goto in my life

Have a look at DllImport

Your code please :-)

I've got LinqPad which is great but I need to understand Linq better - I'm currently watching a series of tutorials on Youtube which is helping but it's not up to your level - where did you learn Linq ? or is it a case of RTFM :-)

I did amend my comment Richard it's exactly what I wanted, where did you learn all this Linq stuff ? it's brilliant

Edit
Sorry Richard it does produce the sums - thank you very much for your help


Hi Richard, thanks for you time - this produced the L values but not the sum of them , what I'm trying to achieve is

H,1000,28-09-2017,2,80
L,30,Pete
L,50,Pete
H,200,29-09-2017,3,135
L,35,Pete
L,45,Pete
L,55,Pete

The values in the L lines 30,35 etc...

Hi Richard this works a treat - how can I add the sum of the L lines ?

Thanks Richard I'll give that a shot

Hi Rick enabling show all characters with both of the files loaded showed me the header record on my file was somehow padded to the width of the rest of the file, the header on the old file is simply MYCOMPANYNAME20170622 but on mine it was written as "MYCOMPANYNAME20170622 128 spaces go here" thanks for your help

Ok I'll give it a go thanks

Good thought i'll give it a go

this is what I ended up with based on your suggestion

Create FUNCTION [dbo].[GetDescription](@Period int)
RETURNS varchar(16)
AS
BEGIN
DECLARE @RetVal varchar(110);

DECLARE @tempTable table (period int identity(0,1),period_descr varchar(16))
insert into @tempTable
select u.period
from Descriptions s

unpivot
(
period for Descrip in (period_descr_0,period_descr_1,period_descr_2,
period_descr_3,period_descr_4,period_descr_5,
period_descr_6,period_descr_7,period_descr_8,
period_descr_9,period_descr_10,period_descr_11,
period_descr_12)
) u;

SELECT @RetVal = period_descr from @tempTable WHERE period = @period
return @RetVal
END

Thanks very much for your help I hadn't even heard of unpivot ! very useful information, as a side note you can't use #temp temp tables in a function

Hi I tried your code and receive this error

(13 row(s) affected)
Msg 245, Level 16, State 1, Line 17
Conversion failed when converting the varchar value 'Description 0' to data type int.

IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp

select u.Descrip, u.period
INTO #temp
from Descriptions
unpivot
(
period for Descrip in (period_descr_0,period_descr_1,period_descr_2,
period_descr_3,period_descr_4,period_descr_5,
period_descr_6,period_descr_7,period_descr_8,
period_descr_9,period_descr_10,period_descr_11,period_descr_12)
) u;

declare @period int = 1
declare @RetVal varchar(16)
SELECT @RetVal = Descrip from #temp WHERE period = @period
select ISNULL(@RetVal, 'Out of range')

OK thanks for clarifying

Where do you declare #temp ? also the table doesn't have a period column only period_desc_0 ... etc

Unfortunately I can't change the schema but thanks for your answer

Hi Peter unfortunately you can't use sp_executesql in a function - thanks for your answer

Apologies to everyone the client I'm currently contracting for has just told me he set all of the records to 31-12-4000 ( it's and end date for a loan ) so that explains it - apols once more

Yes it's date and using default Oracle driver to connect it with CR, see my amended question

Sorry for my tardiness - I'm viewing the inserted data in Oracle SQL Developer

That's similar to what I've done now and it seems to be OK , why are you doing the -5 part though ?

This needs to be done in a SQL Server stored procedure

Sorry I should have been clearer, this needs to be done in a SQL Server stored procedure

What do you mean by it doesn't work ?

Yes I knew that Richard it was the ## I didn't know :-) thanks

Thanks Griff - nice example

Hi there and thanks but that doesn't really help me

Hi Jochen, cpprest has this little gem in basic_types.h

#ifdef _UTF16_STRINGS
typedef std::wstring string_t;
#else
typedef std::string string_t;
#endif
which is what you suggested.
I changed all my wstring to string_t and all is fine - thanks for your time

Really ( You will always run into problems when using std:wstring with Linux ) ? the cpprestsdk team boast of cross platform support - I like to develop using VS on Windows and then copy the code to Linux - I suppose I'll just have to default to using std::string which is not a big deal - thanks for your help.

How do you get tags to show in the message ?

Ok cheers for that

Wouldn't that only catch the closing tag ?

All the *.???x files are zip files

Sorry for not being clear enough by Web report server I mean, the web interface ( which I can't connect to either ) it errors with the same message about insufficient permissions

The web report server or SQL Report Server ?

Hi Ryan, I know you can't see my machine but what I don't understand is *where* do I set permissions ? is it folder security, SQL Server, Report Database ? that's what's doing my head in, You ask Did you log onto the server and run it from the server ? what server the web server or SSMS ? sorry to keep asking but it's very confusing. I had this setup on Win 7 without much trouble but I'm on Win 10 now :-(

I've enabled the checkbox for My Reports folder but don't know how to set permissions to "fix the security" I feel I'm getting nearer though thanks

Thanks,I understand the first part of Properties enable My Reports folder , but when you say "fix the security" I glaze over, how do I fix security ?, my user name is pjk so in SSMS where do I start to "fix security" ? Thanks again

Ok, I'm in Ssms what exactly do i need to do ?

Hi and thanks - how do i turn on My Reports ?

Just to update - if I run report builder as administrator I can connect to the report server and run the report without issue - but I notice if I browse to the report server using Firefox and try to create a shared data source I get the same error about permissions for pjk

Hi and thanks for your reply, if it was SQL server permissions problem why does the report run OK when I'm not connected to the report server ?

Making progress this is the query ( I've substituted the Calendar table with one called Months which has 12 records )

SELECT sq.Owner_Id, sq.MonthNumber, SUM(sf.o_sum_financed) As SumFinanced
FROM (
SELECT ov.Owner_Id, mth.MonthNumber,ov.Opp_Id
FROM Months mth
cross join Opp_View ov
where year(ov.close_date) = 2016
) AS sq LEFT OUTER JOIN O_Sum_Financed sf ON sq.Opp_Id = sf.Client_Id
GROUP BY sq.Owner_Id, sq.MonthNumber
ORDER BY sq.Owner_Id, sq.MonthNumber

and the output is


Owner_Id MonthNumber SumFinanced
BCARR 1 505311.35
BCARR 2 505311.35
BCARR 3 505311.35
BCARR 4 505311.35
BCARR 5 505311.35
BCARR 6 505311.35
BCARR 7 505311.35
BCARR 8 505311.35
BCARR 9 505311.35
BCARR 10 505311.35
BCARR 11 505311.35
BCARR 12 505311.35

where 505311.35.is the total for the year for BCARR - HTH

This the output for REP1 there is a pattern in the summed column which might help you see the problem

Owner_Id MonthNumber SumFinanced
REP1 1 15664651.85
REP1 2 14654029.15
REP1 3 15664651.85
REP1 4 15159340.5
REP1 5 15664651.85
REP1 6 15159340.5
REP1 7 15664651.85
REP1 8 15664651.85
REP1 9 15159340.5
REP1 10 15664651.85
REP1 11 15159340.5
REP1 12 15664651.85

This returns the correct amount of rows but still incorrect summed amounts ( I removed the group clause on the inner query )

SELECT sq.Owner_Id, sq.MonthNumber, SUM(sf.o_sum_financed) As SumFinanced
FROM (
SELECT ov.Owner_Id,MONTH(DateIndex) as MonthNumber,ov.Opp_Id
FROM CalendarTable ct
cross join Opp_View ov
where year(ct.dateindex) = 2016
) AS sq LEFT OUTER JOIN O_Sum_Financed sf ON sq.Opp_Id = sf.Client_Id
GROUP BY sq.Owner_Id, sq.MonthNumber
ORDER BY sq.Owner_Id, sq.MonthNumber

Thanks for your time but I'm still getting the error

This is what I have

SELECT sq.Owner_Id, sq.MonthNumber, SUM(sf.o_sum_financed) As SumFinanced
FROM (
SELECT ov.Owner_Id,MONTH(DateIndex) as MonthNumber,ov.Opp_Id
FROM CalendarTable ct
cross join Opp_View ov
where year(ct.dateindex) = 2016
GROUP BY ov.Owner_Id,MONTH(DateIndex)
) AS sq LEFT OUTER JOIN O_Sum_Financed sf ON sq.Opp_Id = sf.Client_Id
GROUP BY sq.Owner_Id, sq.MonthNumber
ORDER BY sq.Owner_Id, sq.MonthNumber

This is what I have and still getting syntax error

SELECT sq.*, SUM(sf.o_sum_financed) As SumFinanced
FROM (
SELECT ov.Owner_Id,MONTH(DateIndex) as MonthNumber,ov.Opp_Id
FROM CalendarTable ct
cross join Opp_View ov
where year(ct.dateindex) = 2016
GROUP BY ov.Owner_Id,MONTH(DateIndex)
) AS sq LEFT OUTER JOIN O_Sum_Financed sf ON sq.Opp_Id = sf.Client_Id
GROUP BY sq.Owner_Id, sq.MonthNumber
ORDER BY sq.Owner_Id, sq.MonthNumber

Error is: Column 'Opp_View.Opp_Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

but I need opp_id for the join

Where do I put the group by ?

I'm probably misunderstanding what you mean I tried this and get syntax errors

SELECT sq.*, SUM(sf.o_sum_financed) As SumFinanced,count(opp_id) as DealCount
FROM (SELECT ov.Owner_Id,MONTH(DateIndex) as MonthNumber,ov.Opp_Id
FROM CalendarTable ct
cross join Opp_View ov
where year(ct.dateindex) = 2016
GROUP BY ov.Owner_Id,MONTH(DateIndex)
) AS sq
LEFT OUTER JOIN O_Sum_Financed sf ON sq.opp_Id = sf.Client_Id

I've discovered rapidjson has a HasMember method which I think will do the trick thanks

Hi Dave, just to update you - the problem was twofold, the first was I didn't have dotnet 4.5 framework installed which is a must for Powershell 4 and the second was a copy paste problem ( I've had this before copying code from the web ) I discovered if I typed and executed the code line by line in the bottom pane of the ps editor it worked , so I then simply typed the whole thing into a script and Bingo - I'm now obsessed with Powershell - thank you for pointing me in the right direction.

I was thinking that thanks

PS C:\Users\pjk> $PSVersionTable.PSVersion

Major Minor Build Revision
----- ----- ----- --------
4 0 -1 -1

Hi Dave, I updated to version 4 and still the same error :-(

Ok thanks I'll try updating it

Hi there please see my answer to the other chap. Thanks for your time.

Although this is a Sql server database it's a Maximiser CRM database and i think the extra baggage of Maximiser is the culprit. Tnaks for your time.

Hi there I realise there is a limit but no way is this database 15 gig there must be a very large log file that I don't need

Worked with that link Griff thanks

I'm on machine where I'm contracting but it is on SP1

I'm on Win 7 and just installed it as I have all other versions in the past - I'll have another go

Thanks for your time but I'm sure this can be achieved using sockets I've managed to send UDP broadcast messages to the Lan to discover the listening servers using raw sockets so I feel it must be doable having the returned info ( port number, IP address etc...) to send a Post and get the response

Hi there looked promising but it's a commercial product which I don't want

That's a java example for Android - that's why I said in my original post I want a C/C++ solution - I've done lots of googling and seen all these libraries and they are no good to me - thanks anyway

The question is will it compile under my Android C++ compiler ? , I was thinking maybe it's possible using sockets - thanks for your help

Thanks very much - I now have two ways of doing it ( I'm sure there are more )

Thanks very much I always forget you can point the output to another object

Nice one Bill thank you

Thanks very much

I see you fixed the ToLower - thanks that'll do :-)

Oh ok sorry, by code I mean using Crystal Report code this is not a Visual Studio project just a stand alone report

I stated in my post that I KNOW how to do it the way that article does it what I'm asking is how to do it in code

Apologies Dave this is what worked from one of those links

this.client.Credentials = new NetworkCredential("myusername", "myunencryptedpassword"); // where client is WebClient
I was trying it with the encrypted password before - works a treat

I tried those examples Dave and I still get a 401 not authorized error which is not surprising I suppose as the password stored in the .htpasswd file is encrypted - I used this site to generate it
http://www.htaccesstools.com/htpasswd-generator/

and it looks like this
pjk:$apr1$JhJmwyV4$cgtib4PXD9NxL0iGQeg2f1

Thanks Dave

Thats what I've done now Ryan - bit misleading in VS though

Oh ok I'll have to look into the security side - thanks

I haven't tried anything yet as I've only been asked if it's possible - I'm new at Web deployment so don't know what is doable - so you are saying I could create a new virtual directory and put any new stuff in there ? so if my domain was pete.com my sandbox uri would be ( if I created a virtual directory called sandbox ) pete.com/sandbox ?

Ok Richard thanks - I'm thinking of doing it through a WCF service now

Bits ?

Ok thanks that's beyond me at the moment as I've never done any Web stuff

I see it now Richard as I said to the others I misunderstood what UploadFile() does - thanks

Ok thanks I misunderstood what UploadFile() does - I though it physically copied a file but it just POSTS it

Ah ! that would explain it thanks ( I've not done much Web stuff ) so what would be the way to upload a file ? ( there is no ftp server on the box )

Thanks I'll give it a go

As I've said there is no error

new Uri(new Uri(@"http://10.10.1.11/Downloads/Data/"), UploadFname) don't know what you mean by that ? , you have two uri's in there

Edit - oh I see it creates a new URi - I've tried it though ( and got rid of the class complication ) and still no joy - and still no errors

As I said Richard there are no errors the file just doesn't arrive on the server

The question and what have you tried :-)

Eh ? has development stopped ?

Doesn't compile - I'm not using MFC here this is pure C++ - the following code did the trick

json::value jsonValue2 = jsonValue.at(U("result"));

Isn't Casablanca Microsoft ? I need a bare bones C++ example just to get me started I haven't done much web stuff so I want to know the nuts and bolts of how to talk to a server - thanks

Ok thanks

How do you get the angle brackets to show correctly in your message ?

Hi Sascha your solution works except for ( as you mentioned ) when there are more than one with the same maximum Weighting, if I remove the SingleOrDefault() I get an error stating that more than one element has been returned and a problem converting IEnumerable of ints to int, I then replaced SingleOrDefault() with FirstOrDefault() and all is well - so thanks very much

Both solutions are good Richard but until I understand Linq better I would use the first

Looks good Sascha

Hi Sascha I'm using a tablet to post this and don't see an option to comment on a solution

Hi Sascha thanks for that but I need a where clause on BandingEnd as in the real application there would be multiple bands e.g 1000-2000,3000-4000 etc... But I think I can figure it out from your example. Thanks again

Hi Albert what should I use instead of sizeof ?

Why is Wi-Fi not a LAN ? you tell my why it isn't and I'll tell why it is

Hi there , I'm not going to change it I was just being curious - thanks for your time

Didn't realise I'd given you a five ;-) I'm new to this game - thanks a lot

Ok thanks - I just thought there might be a collection such as c# List to store the return value in.

Poor man needs help :-)

I know where it is Griff it's the first call to listener.Receive which is where the grunt work of finding the ip address of a server is done

Hi Dave, the strange thing is I have very similar code written in Java which runs on my tablet and the response is almost immediate - I'm beginning to suspect my laptops wi-fi card

With a slight modification OG's solution worked I changed

byte[] request = Encoding.UTF8.GetBytes("eIPAD\0NAME\0JSON\0");
to

byte[] request = Encoding.ASCII.GetBytes("eIPAD\0NAME\0JSON\0");


and it worked ( i.e. I received the expected data )

Hi Sergey that's what I've tried and I'm not getting the expected result

Success !!! - the colours were set to black on black ( don't know how that happened ) thanks very much

The cursor moves if I type but nothing is displayed

What do you mean nonsense ? It doesn't work - I use cmd.exe for lots of reasons

cmd.exe is there - don't know how to check if it's corrupt

Nothing works

Do you mean Aide ?

Hi there, no it has a static IP address and as I say it runs perfectly as a java module in Android Studio - the problem stems from the RuntimeDegate accessing a null string which must be non null in Android Studio but null on Android tablet

Oh ok - too greedy I think

Hi Bill, I have things working using Matts solution of removing artists that don't have a corresponding album which is not ideal but it does work

Hi Bill I've read that article and it's very good in fact I use some of his methods to talk to the music server. The structure of the classes is very basic unfortunately I can't paste them here because of the formatting but I'll do my best to explain, the Artist class has a ArtistID member as a primary key, the Album also has ArtistID and AlbumID as the primary key, the Tracks class has AlbumID and TrackID as the primary key. Thanks for your interest.

Sorry Bill I should be clearer - yes I get one list of each

Hi Bill, I get a list of albums, tracks and artists - they are part of Logitech Media Server ( used to be Squeezecenter )

Food for thought thanks Bill - you mentioned you could send me something - please do.

I will give that a go Matt thanks

I know what your saying Bill but the data is coming from a source that is not under my control, it's a music database and an artist can exist if they contribute to an album but are not necessarily the *album artist* so an entry is made as a *contributor* but not a corresponding album

I agree totally but the data is coming from a web server as JSon and I have to map it to these existing classes - I hate web work 😑

Thanks Matt that's what I'll do until I can talk to the original dev

Hi OG unfortunately it's not my design but thanks anyway

Hi and thanks, what do I put in the second select ?

Very useful link thank you

Haven't got a solution Dave but if you head over to linuxformat.com someone will help ( sorry couldn't get the link to work ) is that better ?