Comments by Chris Copeland

Chris Copeland 3 days ago View

What does "not behaving as expected" mean? You haven't provided any HTML code or the corresponding CSS, nor have you explained what's happening. Please use the Improve question button and add more details.

Chris Copeland 3 days ago View

Once you've made the initial API call, couldn't you just use regular expressions on your side of the code (PHP) to do the secondary filtering? Ie. find all matches via the API with "CEO" or "OWNER", and then loop through the results and remove any that have the "junior", "assistant" or "president" terms?

Chris Copeland 21-Mar-23 7:24am View

I have plenty of questions about this, as this does not seem like a good solution. However, my main concern is how are you using the numofrecords variable in your GetRecordsInTask method? I get the feeling you're spawning 7 threads, where #1 loads 0 records, #2 loads 100000 records, #3 loads 200000 etc..

Chris Copeland 7-Mar-23 9:39am View

"Make sure that you read this question throughly, and give your decent code answer."
I'm sorry but that comes off as incredibly rude, I think between the solution I've provided and almost the exact same answer on the Microsoft forum you should have all of the information you need to accomplish what you want.

Remember that neither we at CodeProject or on the Microsoft forums are code-providing services, we will simply give you the information and tools necessary to achieve what you need to. I think I've done more than enough to try and help here and I don't particularly appreciate being told to read more carefully nor be expected to provide a complete working solution.

Chris Copeland 7-Mar-23 8:27am View

Here is an example .NET Fiddle[^] which gives a very, very rough idea of how it could work. The rest is up to you!

Chris Copeland 7-Mar-23 7:05am View

One way or another you're probably going to need to have some timer or background task to produce this list of devices, it's not clear in the code how this list is being created but I assume you're manually running some process to get it. If you're after a way to have events raised when devices are added/removed then you'd need to check the documentation on whatever it is you're using to produce the list.

I can't really provide full code but essentially whenever the device list is refreshed (either via a background task or through some events) you'll need to take the new device list, loop over it and add/update/remove items in the observable collection so that both collections match. As I say this will be more work than just updating the item source each time. But any changes to the observable collection will cascade to the ListCollectionView and automatically update the dropdown contents :)

Chris Copeland 7-Mar-23 4:42am View

Can I ask what "But I want to detect if there any item changes happened on it at runtime of the application" means? Do you mean changes to the device list which should propagate down to the combobox, or changes the user might make in the UI which should affect the device list?

Chris Copeland 28-Feb-23 8:15am View

Aside from the immediate code issues, what exactly is the problem you're having? I doubt this exact code would even run, but you've not properly explained what the issue is. Are you calling an API and getting an invalid response? What is the value of the API variable you're trying to use in the the path variable? Is the code throwing an exception, if it is then what does the exception tell you?

Chris Copeland 23-Feb-23 5:32am View

For OP's benefit, here is a good page describing the difference between 'var' and 'let'/'const'[^] just so there's no confusion. var would be required in this solution's suggestion to make it globally available, while let and const should be used in most cases.

Chris Copeland 23-Feb-23 5:28am View

Thanks :)

Chris Copeland 17-Feb-23 5:11am View

I couldn't find anything specific online but what I would guess is that this could be a browser security feature. In no way should any website be forcing the user to download that many individual files, it's no surprise that the browser has limited it to 10. I would check the developer console, no doubt you could see some warnings/errors about too many "createObjectURL" references or similar.

Chris Copeland 16-Feb-23 5:03am View

No particular reason, mostly "replaceAll" requires that the global flag be passed in otherwise it fails, so it simply adds that small validation that it'll affect all instances :)

Chris Copeland 16-Feb-23 4:46am View

Not least of which is what happens if, for any reason, the session end doesn't trigger? To rely on an event like that to clear up resources can be dangerous, especially if you're locking table records. As an alternative, a more appropriate way might be to have a database table which keeps track of uploaded files and they are retained for X hours (could be as short as 1 hour, or as long as 48 hours), and a background job runs every day which looks for files older than X hours and removes them. This would detach the file resources from the session, and also allow you to track uploaded files via the table. But as you say, if this is a large, existing application then it might not be so easy to make such changes (coming from experience, I used to work on a monolithic, 15 year+ application and fortunately we've just started phasing it out, I can understand that sometimes it's not as easy as just "reworking" something)

Chris Copeland 15-Feb-23 5:33am View

Part of the problem is still that there's cleaning that needs to be done when the session ends. In an ideal application, one shouldn't even need to register for a session end event unless it involves removing some table data which tracks the session activity. "perform cleaning an maintenance jobs" is an example of what probably shouldn't be happening when a session ends. This is just my opinion though, I don't know enough about the code base to make any educated suggestions but I would re-evaluate how the application flows if there is cleaning and maintenance to do on a session end. Especially any part of the flow which has any locking tied in with sessions, this is an extremely bad idea which could lead to any number of problems (regardless of whether it's table-level locking, row-level locking, file-locking)

Chris Copeland 15-Feb-23 4:40am View

I'm not au fait with ASP.NET particularly but I think any system which depends on waiting for sessions to end in order to clear up resources is a bad system. Sessions should be used for storing metadata associated with a user or anonymous browser session, and should certainly not be locking records in a table or tracking generated files. I'll repeat that just emphasis, in no way should a session be locking table records.

Chris Copeland 2-Feb-23 6:43am View

This literally sounds like Amazon/eBay, except with the added nuance of having a "smart conversation" feature? I'm sure customers would just prefer to be able to select some radio buttons/dropdowns and click a button than enter into a conversation with someone. Plus, as Dave rightly mentioned, you're really not going to be able to stop the supplier/customer from identifying each other and passing along contact details (phone numbers, email addresses, morse code).

Chris Copeland 2-Feb-23 6:37am View

This seems like a duplicate/extension of this question you already raised[^]. You haven't particularly made it clear what it is you're trying to accomplish.

Chris Copeland 2-Feb-23 6:35am View

It depends exactly what you're trying to do, as I say it depends how you're serving your pages. You're either using server-side rendering via PHP or a similar backend framework, or you're serving your pages using a client-side framework like Angular/React. If you're not using either of these then you're creating static pages which, depending on the requirements of your project, may or may not be suitable.

Chris Copeland 31-Jan-23 8:53am View

I did say in my answer you'd need to adjust your code to pick the first group matched, not the whole text. Here's an example JSFiddle[^] showing how to do that. The first [0] value will always be the whole match but the subsequent values [1+] will be the groups.

Chris Copeland 31-Jan-23 8:44am View

Sorry but I don't seem to understand what's not working, from reading the initial question you wanted to match the "code civil" in the sentence but not the one in the parenthesis, which is what the result of that regex seems to be doing? What part of it is not working?

Chris Copeland 31-Jan-23 4:38am View

I don't understand the comments you've been leaving, you're selecting values from the table where the field type must contain "Get Subscription", status code must contain 200 and the output must contain success. You said below "but distinct not work with not null values" which doesn't make sense, what exactly are you using Distinct() for, and what are you expecting to happen here?

Chris Copeland 27-Jan-23 4:47am View

If you're trying to get it to scroll horizontally (which is odd, a menu shouldn't be scrollable horizontally, usually it's done vertically) then you may need to add a max-width: 100vw property to the .top-bar-section class. CSS needs to know how wide the container will be before it can introduce scrolling. Also (not related to this question) you have two directly nested <ul> elements which isn't valid HTML.

Chris Copeland 25-Jan-23 10:33am View

I just noticed that the link you provided is an example page, I opened the page and manually appended #pastperfectcontinuous to the end and the browser window did actually navigate to that element, so I don't see the issue?

Chris Copeland 24-Jan-23 9:29am View

I see, I notice you're using data-fancybox which I believe is a reference to the jQuery lightbox plugin. It's entirely possible that this plugin is changing the DOM structure of your page which means the element could be being affected. Unfortunately I don't know enough about the plugin to make an informed guess but you could try inspecting the HTML elements within your browser (typically right-clicking the element and choosing "Inspect" is enough), and you should be able to see whether the page is the same. Here is an example of the anchor working[^], so the scrolling shouldn't be an issue.

Chris Copeland 23-Jan-23 5:35am View

No need to apologise 😊 it's just very easy to get carried away when writing code and things can become difficult to follow very quickly! I wasn't criticising your English (no complaints from me there), just wanted to highlight how important it is to keep code simple and easy to follow. If you break the code down into more manageable chunks I imagine you may have a better time working out which parts aren't awaiting correctly!

Chris Copeland 18-Jan-23 4:57am View

You've already asked this question here[^] and an answer has been provided to you.

Chris Copeland 21-Dec-22 4:34am View

Did you not mean to refer to tile_data.Type instead? Remember that C# is case sensitive, you're trying to access the type field which is inaccessible; you instead need to refer to the Type property.

Chris Copeland 15-Dec-22 8:07am View

This is generally caused when DNS isn't able to resolve a domain name or host name to an IP address. For example, if the txtRequestURL.Text value contained "http://iamnotavaliddomain.com/" (which isn't an actual website) I would expect you'd get that same error.

Chris Copeland 6-Dec-22 4:53am View

Have you tried debugging the code in the developer tools, stepping through the code line-by-line and seeing what each of the values are?

Chris Copeland 3-Dec-22 15:20pm View

What are the types of authorId and author.id? The === comparator checks for types as well, so if author.id is a string and authorId is a number, the find() would fail. You can check using typeof(authorId) and typeof(author.id). If they're not the same then that explains the problem.

Chris Copeland 2-Dec-22 6:12am View

So you've already created the table and you're trying to create it again? Why? Once you've created the table you can either alter it using alter table commands, or drop it completely using drop table commands (though this will erase all the data in the table)

Chris Copeland 1-Dec-22 4:15am View

I don't fully understand what the issue is here, though I have doubts about what you're trying to achieve with the above. For a tab control you shouldn't need to use transform: translateX() but I guess that's a different story. I doubt that the margin-top of the <p> element is changing, are you sure it's not just moving relative to the content displayed in the wrapper element?

Chris Copeland 30-Nov-22 8:05am View

I think that comes down to more the use-cases. If the application you're building doesn't need to display or use the product information then there's no point in adding it in 🙂 however if you do want to display the products you'll need to come up with some way of doing it. You should take a look at the requirements for this application and decide the best way to implement it!

Chris Copeland 30-Nov-22 6:07am View

I think the example I've provided could easily be integrated into the code you've already got. I kept some of the variable names the same, so you can just use my code as a template? The key point was to illustrate that it's better to explicitly reference the JSON properties than dynamically.

Chris Copeland 29-Nov-22 7:50am View

Have you tried taking out the select query and running it separately to confirm that it does return some results? If it doesn't return anything then nothing will get inserted. If it does, and you expect the insert to have worked, it sounds more like a committing issue.

Chris Copeland 28-Nov-22 9:46am View

In what way does "sorting not work in Firefox"? Does it throw an error or are the items not sorted in a way that you expect? If the latter, you need to account for undefined values as part of the function.

Chris Copeland 28-Nov-22 9:44am View

That error means that it cannot find a variable named $mysqli. You may have converted your code and forgotten to rename some variables?

Chris Copeland 28-Nov-22 9:43am View

The error is telling you quite clearly what the issue is. It's expecting a salesProductWeight value to be passed into the controller as part of the request, however it's not able to find it. You've provided the code for the controller but not the part for the Javascript, which is what is important here. You can use the Improve question button to amend your question with the relevant code.

Chris Copeland 28-Nov-22 9:42am View

Deleted

The error is telling you quite clearly what the issue is. It's expecting a salesProductWeight value to be passed into the controller as part of the request, however it's not able to find it. You've provided the code for the controller but not the part for the Javascript, which is what is important here. You can use the Improve question button to amend your question with the relevant code.

Chris Copeland 28-Nov-22 4:15am View

You've provided code for the getting part of the process but you've not provided any code for the submission part. Also I got validation error isn't very specific, try and provide more details. Did the validation error occur in the backend, the frontend, and what exactly did this validation error say?

Chris Copeland 15-Nov-22 8:10am View

As you say, trackingElement.closest('[data-tracking-filetype]'); throws an error because trackingElement is null. You need to investigate why it's null. If you're always expecting the value to be non-null then you need to take a look at the part of the code where it finds that element. That's a part of code which we can't see, so can't provide any help with.

Chris Copeland 14-Nov-22 11:47am View

I'm unable to reproduce this result. I copy + pasted the exact code above into JS fiddle, then manually set each of the variables to the values you've described and I get the correct answer. There must be more to this than what we can see. For example, could some of those variables actually be a string instead of a number?, that could affect the result.

I will say this, if you sum together all the values except the "4" from the off_qi variable you end up with 3.05, which is close.

Chris Copeland 1-Nov-22 9:13am View

I did not know that, thanks!

Chris Copeland 31-Oct-22 9:19am View

Yeah I dropped a similar comment on the question. I'm not surprised at all that some servers don't handle things like that, I can't count the number of production APIs I've had to integrate with that churn out 500s like no tomorrow..

Chris Copeland 31-Oct-22 6:13am View

A 500 error code could indicate you're sending across something unsupported by the server. If a server produces a 500 response it could mean they're not setup to handle a certain scenario, so I'd maybe look at the XML content you're sending across and whether you're using the correct URL with the correct headers.

I'd also advise debugging the code (put in a break-point somewhere) and check the content you're sending across. It looks like you're calling both soapEnvelop.load() and soapEnvelop.LoadXml() which is strange.

Chris Copeland 28-Oct-22 14:42pm View

There's not nearly enough information in this question to help. If the totalEffort value is incorrect then the issue is with where this value is being pulled from, not the HTML code itself. You haven't provided that part of the code so we're not able to help.

Chris Copeland 27-Oct-22 4:27am View

Usually this means a variable that you're referencing has a value of undefined when you try to read the property (as the error suggests), however in the code you've provided there are no path references.

You need to use the developer tools console to look at the error, it should tell you exactly which file and line is causing the issue.

Chris Copeland 19-Oct-22 4:13am View

Just out of curiosity, why aren't you using <button type="reset"> ?

Chris Copeland 14-Oct-22 6:42am View

I did read your comment but it still doesn't provide anywhere near enough information to understand what the issue is. Saying it "does nothing" doesn't help identify what the issue is, and "the code does nothing to the site." is very vague, your code shouldn't do anything to the site.

Imagine if I had a problem with a piece of code: int number = 1 + 2; and I raised a question and said "I'm running this piece of code but when I put a breakpoint on the line and step through the code does nothing". You'd be wondering, "Well, what is it you expected it to do? What is the problem with this line of code? What do you mean by nothing?"

This is a similar situation, we're not running this piece of code, we can only observe what you tell us. As I asked before, is it that the SelectNodes() method isn't producing any results? Is the code above throwing an exception? If you debug the code and step through line-by-line, what exactly happens?

Chris Copeland 14-Oct-22 6:00am View

You've still not explained what isn't working! Is it throwing an exception? Is the call to SelectNodes() not producing any results? We haven't run your code so we don't know what the result of this is, we need to know what behaviour you're expecting and what the actual behaviour is.

Chris Copeland 14-Oct-22 5:00am View

What do you mean by not working? You haven't told us what the issue is with the code!

Chris Copeland 12-Oct-22 4:14am View

Deleted

I'm not familiar with ASP.NET but from looking at the code your controller is decorated with [Route("Register")] and the insert user method is decorated with [Route("api/Register/InsertUser")] so wouldn't you need to combine those to get the full path? I suspect the path would then be http://localhost:54111/Register/api/Register/InsertUser ?

Chris Copeland 4-Oct-22 5:25am View

I didn't refresh my screen, you got in before me! 😆

Chris Copeland 4-Oct-22 5:24am View

Just to comment on this, that's not really what the filter() method is for. That method is supposed to return true or false to indicate whether the resulting array should contain that element. In this example you would only need to do:

anArray = words.filter(word => !word.includes('e'));

Chris Copeland 4-Oct-22 4:25am View

If Azure.Identity requires .NETStandard 2.0 and if VS 2013 does not fully support that then you need to either upgrade your version of Visual Studio (Community edition is free so why not get a newer version?) or move over to VS Code which I think supports it too.

Chris Copeland 28-Sep-22 6:52am View

If you're trying to connect to the same machine, use 127.0.0.1 rather than localhost. Otherwise, a connection being refused typically means a firewall has prevented the port being accessed, or the port is inaccessible for some reason.

Chris Copeland 11-Sep-22 14:42pm View

Passing values to a function is one of the most basic concepts of programming. Here's a good page providing an example[^] which you can use.

Chris Copeland 6-Sep-22 5:05am View

As Griff said, use the debugger by putting a break-point on the line where you call CrianovaAba(); and see what the value of Application.Current.MainWindow is. The as cast will return null if the value of that property is not a MainWindow instance.

Chris Copeland 2-Sep-22 4:49am View

This comment doesn't make sense, and I assume you also down-voted my answer? ASCII has nothing to do with the spaceship operator, my answer explicitly states that the operator functions much like the strcmp function but capped to -1, 0 and 1.

Chris Copeland 31-Aug-22 5:55am View

You're welcome :)

Chris Copeland 31-Aug-22 5:36am View

That sounds like your code isn't able to find the correct container. See this StackOverflow question[^] which seems to explain the problem.

Chris Copeland 16-Aug-22 6:52am View

Then I suggest you take a look at the link I provided, this is where debugging comes in. As a developer you'll need to learn to run and debug your code, as in step through the code line-by-line and inspect the variables to see what's happening. If there are errors then it should show in your developer console window.

As for checking local storage, under Chrome you can open your developer tools, navigate to the Application tab, then find and expand the Local Storage option and there should be an entry in there to be able to see your local storage.

We can't validate if this code works for you, you'll need to do that part of the work yourself. We can only advise if you know there's something wrong with the code and can give us the information we need to be able to provide advice.

Chris Copeland 16-Aug-22 4:39am View

If the files aren't too large (ie. less than 2MB) you might want to also consider debugging the code and seeing what these variables are producing. I don't know what the readFile() method is but it's always worth having a check to see if any console errors are being produced and debugging it to see what the values of each variable are. Could just be a permissions issue?

But if there is a chance users could be uploading larger files then it's definitely worth looking into an alternative way of handling this, even if it's just adding a check to prevent too-large files from being uploaded (Blob.size[^])

Chris Copeland 16-Aug-22 4:21am View

I wouldn't say you've improved your question much, you've not told us what's happening, what you expect to happen. What is it you're confused about? Also, have you done any debugging of the code[^] to see what's happening?

Chris Copeland 9-Aug-22 12:24pm View

My bad again, I had a typo in the code. I had suggested JSON.parse(cartItems); instead of JSON.parse(cartItemsJson). The error you got though told you the exact problem and which line to look at so you probably could have figured that out yourself!

Chris Copeland 9-Aug-22 8:15am View

Sorry I forgot I omitted the part where you actually grab the cart items from the local storage. I've updated my answer accordingly.

Chris Copeland 28-Jul-22 8:51am View

So you should be able to work out the rest. Remember that you need to update each form element with values from the array item, like so:

const item = array[index];

el.number.value = item.numberNew;
el.label.value = item.labelNew;

.. etc

Chris Copeland 22-Jul-22 7:41am View

Have you tried debugging the Javascript/Typescript? Looking back at your original question it sounds like the new value from the input isn't being passed into the function correctly. Try printing out the message in the sendMessage() method and check that the value has actually changed. I just noticed you're giving the input a template reference #refVariable and accessing the value through that. You probably shouldn't do that, you could get the new input value in one of two ways:

1. Give the input an id attribute and use:

const element = <HTMLInputElement>document.getElementById('id here')!;
const message = element!.value;

2. Use reactive forms to bind the input value to a FormGroup object, and get the input value through that: https://angular.io/guide/reactive-forms[^]

Chris Copeland 21-Jul-22 4:29am View

And? Is there a question here? All you've done is provide us with a list of objectives and the HTML code you've produced.

Chris Copeland 13-Jul-22 11:17am View

I gave you all of the information needed for you to work out what the issue is yourself. CodeProject is not a code providing service, we won't code everything for you. Already in this question you've been provided a direct answer and are now asking why it's not working in your application and expecting to be provided code that will work; that's up to you to figure out.

As a developer you need to learn to use logic and reasoning when creating code, see where it fits in your application and if it doesn't work, use development/debugging tools to inspect why. Look at your console window in the browser and see if you get any errors. In this example, if your button isn't visible then where did you put the button in the page HTML structure? Did you put it in the correct place?

Chris Copeland 13-Jul-22 9:41am View

This is a follow on question from the existing one you raised here[^]. I already told you how to fix your issue, you didn't need to raise a second question.

Chris Copeland 13-Jul-22 8:08am View

As I said in my previous comment, I won't provide you the code, I've already explained what it is you need to do. I recommend you check out this JavaScript Strings page[^] (look for the Escape Character section) to understand why you need to escape the apostrophes (').

I'm more than happy to provide nudges in the right direction, but if you want to learn how to code then you need to invest the time and research yourself.

Chris Copeland 8-Jul-22 6:31am View

I won't provide you with the code, if you're interested in getting into web-development then I recommend you start by looking at some tutorial websites. Everyone has to start somewhere and asking for code to be given to you is no way to learn. Take a look at the below websites for a good starting point:

HTML Tutorial - W3Schools[^]
JavaScript Tutorial - W3Schools[^]

Chris Copeland 8-Jul-22 5:34am View

You're getting that error because you've got apostrophes (') inside your string. You need to escape any apostrophes inside your string with a backslash (\), for example: 'This is text \'and\' this was escaped'

This is also basic Javascript knowledge, I recommend you look at some JS tutorials online. Also, why are you printing a button to the page that links to an executable file when the text of the button is Upload Image? That seems dodgy.

Chris Copeland 7-Jul-22 5:10am View

No, the CSS example you've provided is using the . selector which means "elements with this class", not by using ID. In CSS using .example would match to elements with class="example" while #example would match elements with id="example" (this is basic CSS knowledge, so if you're unsure or confused on this then you might need to look at some CSS tutorials)

To answer your question about changing the IDs, you assign the ID in the HTML part of the script you provided. What you probably need to do is either use an ID column that is returned from the request response, or just have a var counter somewhere in the script outside of the loop where you add the checkbox HTML. You can increment the counter for each row, and make sure to append it to the id attribute. See this example for how you can append the counter[^]

Chris Copeland 5-Jul-22 4:16am View

The server-side only produces HTML content, when the browser sends a request to the server-side for a particular web-page it receives essentially a text response back containing the HTML structure to display. It's up to the client-side to render this web-page, so no rendering gets done on the server-side.

For any and all websites where there are interactive buttons and inputs (including here on CodeProject) they handle user inputs in one of two ways: server-side processing (which is where the whole page is navigated/submitted and the server must process the actions and resend any pages back to the browser) or client-side processing (which is where the browser makes asynchronous requests to the server-side to handle each operation) (See here for comparison).

Unfortunately this is just the way things are with development, some websites user newer tools such as WebSockets to open up channels to the server-side, but otherwise most processing is done through either fetch() or XMLHttpRequest.

Chris Copeland 4-Jul-22 12:04pm View

Yes, remember that assigning a variable will overwrite what was previously there. If you're looping twice because you have two records, the first loop will assign the variable to a date, and then the second loop will then assign the variable again, replacing what was already there. Using PHP arrays you can assign multiple values to one variable (See this documentation page) or you could concatenate a string to contain the dates, using a comma to delimit them (See this documentation page)

Chris Copeland 4-Jul-22 11:03am View

Okay I can see you've updated your code now. This is probably because you're looping over the multiple records however you're assigning the values to the same variables:

$start_datum = date('d-m-Y', strtotime($row['start_datum']));
$eind_datum = date('d-m-Y', strtotime($row['eind_datum']));

What's going to happen is the first result will be looped and assign the dates to these variables, and then the second result will loop and assign the new dates to the same variables, overwriting the results from the first! You probably instead need to store these dates in a PHP array, and then later in the script loop over the PHP array to print them in the Javascript part.

Alternatively, you could build a comma-delimited string and then just print out the string instead. I won't tell you how to do either of these approaches, you're probably better off doing some research online and working it out for yourself 😊

Chris Copeland 4-Jul-22 10:47am View

I think foremost you need to re-examine the structure of the PHP page. Make sure to put scripts in the appropriate places and only loop where you absolutely need to. If your query is only ever returning one result however then for now the code you have should be fine.

As for other dates in the database not being excluded, well your query SELECT * FROM reserveringen WHERE huis_ID = ? only returns one result. If you want other start/end dates to be excluded you need to run a second select to select all start/end dates from the database, and then apply them to the script where you exclude dates.

Chris Copeland 4-Jul-22 7:07am View

What are you going to be doing with the rows that are selected? It still sounds like it needs to be client-side. For example, if you're planning on allowing row selection and then the user clicks a button, what you'd want to do is on the client-side add an event listener for the button click, and then you'd get the selected rows by doing something like document.querySelectorAll('input[type="checkbox"]:checked') which would produce a collection of checkboxes which have been checked. You would then use the data from these checkboxes to build some sort of request to the server-side to perform an operation.

Here is a super simple example[^]

Chris Copeland 4-Jul-22 6:04am View

Can I ask why you would need to get the checkbox instance on the server-side? Anything on the server should be business logic (performing operations such as data manipulation, transformation, persistence etc.) while on the client should be anything the user can view and interact with. You can't expect the server and client to have access to the exact same HTML elements because that doesn't make sense.

Any event listener for listening for checking events, or button clicks, or text inputs, need to be done all on the client-side, the server doesn't need to be aware of any of these sorts of events. Instead, when the client-side event is triggered (ie. a button click or check event) then the client-side can send a message to the server-side via something like the fetch() API or an XMLHttpRequest to indicate that something has happened. So if the user clicks a "delete" button next to a row on their screen, you'd expect the client-side to send a "delete this record" message to the server-side with information on what record to delete.

Chris Copeland 4-Jul-22 5:18am View

Repost of https://www.codeproject.com/Questions/5336107/How-do-use-a-label-HTML-element-as-a-variable-in-J

Chris Copeland 4-Jul-22 5:02am View

This SO answer has a good example of how to achieve that. You need to maintain a variable to store the current "page", and a variable to store how many items should be displayed per page. You'd need to add a "show more" button and when that's clicked, increment the current "page" and then select a range of values from the array based on the "page" and the count. Ie:

let page = 0;
const count = 2;

// On first load
const items = array.slice((page * count), (page * count) + count);

// On second load
page++;
const items = array.slice((page * count), (page * count) * count);

Chris Copeland 4-Jul-22 4:43am View

I think this depends on how you're rendering the content into a table. I don't have much experience with running a Node.js server so I'm unsure of it's capabilities but I would have thought you'd need to create the checkbox element on the client-side. Surely the purpose of the server is to provide a sort of REST service (which means basic JSON in/out), and the client-side should be building the table and the components within it. If you make the client-side do the work of creating the table, then you should have somewhere in that piece of code which creates the checkbox to which you can bind the event listener.

Alternatively if the client-side JS is happy to render the checkbox returned from the server-side, then you need to add a post-rendering event listener to handle that.

Chris Copeland 29-Jun-22 10:14am View

As I said, you need to check that the dJson6 variable has values in it. I'm not familiar with using JavaScriptSerializer (please see the extra comments in my solution, you shouldn't be using this class but instead using either the built-in JsonSerializer class or using the Newtonsoft.Json package) so I can't tell you how to do that, but if I was to guess I would think there'd be a Length property on the value. If there is, you need to first check if the length is greater than zero, and then check whether the first element is null or whitespace.

Chris Copeland 29-Jun-22 8:30am View

The server-side cannot interact with elements rendered on the client-side, these are two very different entities. As you said, you're performing a GET request and populating a table, presumably it's when the table is populated that the checkboxes are created. If you want to interact with the checkboxes (ie. perform some action on the server when a checkbox is checked) you need to register event listeners on the client-side, and then perform additional GET/POST requests (or use WebSockets) to communicate with the server-side to tell it what to do.

Remember, you'll need to register the event listeners only after the table has been populated. How that happens is down to your code (which we can't see in this question).

Chris Copeland 27-Jun-22 4:21am View

Are you aware that for this: link.style.animation = 'navLinkFade 0.5s ease forwards ${index / 7 + 2}'; you have to use the ` symbol as the text quotations if you want to use string interpolation? Ie: link.style.animation = `navLinkFade 0.5s ease forwards ${index / 7 + 2}`;. This could explain the error, can you change this and try again? Template literals (Template strings)[^]

Chris Copeland 14-Jun-22 9:37am View

What exactly isn't working? The code you've provided is to send a simple email (which, by the way, it's never safe to put your SMTP username and password in the Javascript on the web page; you should instead be sending emails in the server-side code where applicable) however your description seems to indicate issues with accounts?

If the issue is with the above JS code, have you considered using the developer tools of your browser to check the console and see whether you get an error message? Remember that JS promises also have a catch() method you can use to check for errors.

Chris Copeland 27-May-22 8:14am View

Can you check in the developer tools console/network tabs whether the stylesheet is loading correctly? It's quite common for browsers to limit certain operations when running from a local file for security reasons. It could be your browser is either not loading the remote CSS, or your browser (ie. Chrome) is blocking access the stylesheets rules because of things like CORS.

Chris Copeland 27-May-22 8:10am View

I guess so, see this StackOverflow answer[^] for details on ensuring the canvas is resized correctly.

Chris Copeland 27-May-22 6:59am View

You may need to play around with setting the canvas dimensions via JS based on the document height and width. Ultimately I think this would be the best way to go, but the example I put together was just a proof-of-concept really 😊

Chris Copeland 27-May-22 5:07am View

CSSStyleSheet.rules - Web APIs | MDN[^] is deprecated, have you tried using CSSStyleSheet.cssRules - Web APIs | MDN[^] instead?

Chris Copeland 23-May-22 6:48am View

I'm not going to write any WPF as that would require me to create a VS solution and write up a lot of code, but from your Machines class it would look something like:

public class Machines {

  public Machines() {
    Statuses = new ObservableCollection<Status>();
    for (int i = 0; i < 60; i++) {
      Statuses.Add(new Status());
    }
  }

  public ObservableCollection<Status> Statuses {
    get;
    set;
  }
}

From there you can use the binding to the collection such as <ItemsControl ItemsSource="{Binding Statuses}"> which will then automatically bind the elements of the collection to the control. I also believe this registers for PropertyChanged events so if anything changes in one of the statuses, the ItemsControl will update the data template.

Chris Copeland 17-May-22 15:15pm View

How is the image in the database encoded? Is it a raw binary column or a string column?

Chris Copeland 11-May-22 6:36am View

What code is present in the config.php file? Your page is trying to read the $resultAll variable for a MySQL query result but you've not actually defined that variable within that page. Where are you defining that variable?

Chris Copeland 11-May-22 4:13am View

Before someone swoops in with the fact you're using string concatenation/interpolation for the SQL query when you shouldn't be, the error you're getting as exactly what it says. The $con -> query line cannot execute because this $con variable doesn't exist. You need to check your config.php file to make sure that the variable is definitely called $con

Chris Copeland 10-May-22 5:03am View

There doesn't seem to be enough context on this question to make an educated answer, where are you trying to show the color and where is the code for the OrigSiteChange() method?

Chris Copeland 28-Apr-22 6:17am View

Maybe I'm mixing wires here but you have print( json_decode( $rows ) ); which takes a string value and converts it into a PHP object, shouldn't you instead be using: print( json_encode( $rows ) ); which takes an object/array and converts it into a JSON string?

Chris Copeland 25-Apr-22 5:29am View

Can you try moving the <input type="submit"> so it's within the <form> elements? Otherwise move the <form> elements so they sit around the button? I'm wondering if there's some weird browser quirk which submits the only form on a page when the submit button isn't within the form itself, and maybe because the submit button is outside of the form it's not picking up the inputs.

Chris Copeland 22-Apr-22 6:33am View

I agree, I won't be following the link either. A picture is no good if we want to copy + paste problematic parts of the code to provide guidance. That being said, I think the error explains itself, you're passing an array into the mysqli_connect parameters when that function does not expect any array values at all.

Chris Copeland 21-Apr-22 6:09am View

This code that you've submitted looks incomplete and incoherent. Can you use the Improve question button to properly submit any code you're using, and also use the <pre> tag to correctly format the code so it's more readable? I can't see any code there for the actual form itself.

Chris Copeland 12-Apr-22 5:20am View

This goes back to my original point, what research have you done? I see the question is aimed at C# so you need to decide whether you're building a web-based server software, or something like a traditional Windows-service based software. Then you just need to do some searching online to find the right documentation and tools you'll need to build it. Here, I did a very quick Google search[^] and it provides some recommended pages from Microsoft, along with others.

Learn to use websites like Google and Stack Overflow for what they are, enormous repositories full of information. If you end up wanting to perform some sort of function in the future, lean on these to ask the question "How do I ..." and undoubtedly you'll get the answers you're looking for. Then, when you're coding the solution, if you have issues with your code that you can't figure out then we'll be happy to provide help!

Chris Copeland 12-Apr-22 4:58am View

Part of the problem you're having is you're not doing your own research and consulting learning resources. If you just keep asking us questions and demanding that we assist you with development ("then you have to assist me the way i feel fruitful to me.") then you're never going to learn how to code independently, nor understand what it is that's being coded.

As I mentioned on a previous question, a huge part of being a software developer, when diving into unfamiliar territory, is simply searching online for explanations of the technology you're trying to use, best practises for implementing said technology, and how to achieve what you're after. This website doesn't provide peer-programming, we won't hold your hand while you code, but we can provide advice on pieces of code when you get stuck. If you're not even attempting to code anything then we can't help you.

Chris Copeland 11-Apr-22 8:05am View

You've already written code to do the initial authentication, so the remaining process should be easy? You have the access token and the URL, so you just need to build the URL using the instance_url variable (ie. ${instance_url}/services/data..) and pass in the token to the header like you did with the client ID and secret (ie. headers: { "Authorization": `Bearer ${access_token}` })

Chris Copeland 11-Apr-22 6:44am View

This is not the way to connect to databases, you need to use the relevant ODBC connectors and/or frameworks for interacting with databases. The System.Diagnostics namespace is designed for debugging and diagnostics (as the name suggests), it should not be used for maintaining connections to databases. Especially starting a new process in order to connect to one..

Chris Copeland 7-Apr-22 9:27am View

Is the request rejected if the username token doesn't begin with UsernameToken- or are you just comparing the token you're generating with others? If it works then presumably it's the correct way to do things. You'd need to consult the documentation for both the SOAP API you're using, and the C# library that you're also using to make the API calls.

Chris Copeland 6-Apr-22 6:02am View

This code is both incomplete and invalid, this wouldn't run at all within a browser. Can you post the most up-to-date and complete solution you've tried?

Chris Copeland 31-Mar-22 9:47am View

You're most welcome :)

Chris Copeland 31-Mar-22 4:19am View

Can I ask exactly what decimal formats you're trying to match/validate against? Your regular expression pattern doesn't make much sense to me, specifically: ^.{0,5}$ which is "any text between 0 and 5 characters in length". Can you make it clearer what sort of decimal formats you're expecting to be supported? \\d{0,2} also indicates you only want to support whole numbers between 0 and 2 digits in length?

Chris Copeland 30-Mar-22 9:56am View

Tutorial: Debug C# code - Visual Studio (Windows) | Microsoft Docs. OriginalGriff has already explained that you need to use the debugging tool to work out what's causing the exception. When the exception happens your debugger should stop on the line that caused it, allowing you to inspect the variables to work out what happened.

No one is willing to download this RAR archive you're trying to send, you need to learn to use the debugger to solve problems like this. Visual Studio will give you all of the information you need to look at the state of your application and see what part is the problem.

Chris Copeland 30-Mar-22 9:16am View

Goto - I know, but that's no reason not to. -- there absolutely is a reason not to. Modern developers do not use these semantics, so it's better to understand from the start that you shouldn't be using them. If you decided to join an open source project, or start your own, or tried to get a job in a development role, and you were using goto as part of your development then there's a good chance you'd be in trouble.

Aside from that, it also makes code more difficult to read than it needs to be. With appropriate if, while and return/break/continue statements and correct indentation, code becomes much easier to read. Remember that while it might seem an okay practise for yourself to use, asking for help on code which is difficult to read isn't likely to trigger many responses -- aside from the one you've already seen: "Don't use goto"

Just my two cents, you can take it or leave it. I recommend you do move away from using goto when developing code however.

Chris Copeland 30-Mar-22 9:08am View

What you have is a form with a submit button. When the user clicks the submit button (or probably presses ENTER in the text field) the browser is going to submit that form, which will redirect to a different page (probably the same page but with '?' at the end of the URL). When the browser redirects, it will cancel any Javascript running on the previous page.

As per my example in my answer, you can cancel this browser redirect by calling e.preventDefault(); which tells the browser that you're essentially going to handle things yourself (via Javascript). This should ensure that your Javascript code in the sendMessage() function gets executed completely without interruption.

If it's still not working after my recommended change, you might need to use the developer tools in the browser to look at the console and/or the network requests to see what's happening in the background :)

Chris Copeland 29-Mar-22 6:30am View

Deleted

For clarification before I attempt to add an answer to this, what is $bdd? Are you using the MySQL PHP functions/classes or the PDO functions/classes? It's a little unclear from the code.

Chris Copeland 29-Mar-22 4:31am View

There's not really enough to go on here, what do you mean the "input field moves/flips with table row"? We need more than just the HTML for the input, there might be something wrong with the structure of the table itself?

Chris Copeland 28-Mar-22 4:26am View

Deleted

I don't quite understand the question, in none of the code above are you trying to "access the class attached to that content". Can you explain more clearly what the issue is?

Chris Copeland 24-Mar-22 5:27am View

This question doesn't quite make sense, you're asking to be able to make a notification display on a device available on the network, without any additional software being added onto the client? Then no, that's not going to be possible, not unless one of these devices has some documentation somewhere which allows for UDP-based notifications, but I highly doubt it. What sorts of devices would you need to be sending notifications to anyway?

Chris Copeland 22-Mar-22 5:17am View

Wasn't aware of this property, I learned something new today!

Chris Copeland 22-Mar-22 5:15am View

As I said, you actually can't style the native checkbox itself, you'd have to create some special HTML code to handle it for you (like I did in my JSFiddle). Please also see this StackOverflow post[^] which pretty much says the same thing. I don't know why CSS styling for a checkbox isn't a thing, but here we are!

You could also use the mat-checkbox on each row and apply styling to that? That does exactly what my code does, which is replace the native checkbox with a pseudo-one!

Chris Copeland 10-Mar-22 4:32am View

If the hard-coded version works, but the variable version doesn't, then there must be something wrong with the value of the day variable. It could be something as simple as the year not being properly formatted, or any one of the d, m or y variables not being correctly assigned.

Have you tried debugging the code in the browser? You can set a breakpoint on the line and inspect the value of the day variable, otherwise you can also use console.log(day); to print out the value to the console.

Chris Copeland 4-Mar-22 5:01am View

Also the same as https://www.codeproject.com/Questions/5326542/Method-illuminate-database-eloquent-collection-res, just slightly different. Seems they keep raising questions for the same piece of code rather than just amending a previous one.

Chris Copeland 3-Mar-22 8:06am View

A very quick Google led me to:
How to restore/forceDelete multiple item at once time in Laravel using soft delete

Apparently you can't use the restore() method on a collection, it has to be on the Eloquent object itself.

Chris Copeland 1-Mar-22 8:39am View

Consider using map()[^] which is used to convert an array of values into another array. The documentation on there is pretty comprehensive so you can use it to work out other things. A lot of what you're asking is basic coding questions so it might be worth reading up and looking at some examples!

Chris Copeland 1-Mar-22 5:01am View

Take a look at my Math Equation Parsing using Call Stacks article.

Chris Copeland 1-Mar-22 4:57am View

If what you want is "ISO code by country name" then yes you would need to provide a country name every time you wanted an ISO code. If you're reading the country name from an input then you can simply use the input value directly in the filter() method.

Otherwise, the alternative would be to map all of the countries to an object like so:

const countriesByName = {};
countries.forEach(c => countriesByName[c.name] = c.isoCode);

Then accessing the object direct via the country name would give you the ISO code:

console.log(countriesByName['Iceland']);

Chris Copeland 18-Feb-22 8:42am View

I'm confused, you disabled right-click for safety but now you want to enable it again? If this is the case, just undo the change you made to disable it in the first place.

If you're asking whether it's possible for someone to gain access to the right-click context menu even with your JS change, then yes it's entirely possible.

Chris Copeland 17-Feb-22 10:47am View

I still can't see any JS or HTML code relevant to this problem. You've not shared anything which can be used to diagnose the problem. For example, I don't know what this findnext is, so I can't provide help!

Chris Copeland 17-Feb-22 5:21am View

You haven't provided any HTML or JS code, only CSS code. It's going to be difficult to help provide a solution when we can't see what you've attempted already. We can best guess, but if you're using a library like jQuery then it'll be much simpler than using vanilla JS.

Can you include the JS code you've managed to produce and some example HTML?

Chris Copeland 10-Feb-22 10:10am View

You haven't provided enough code for us to work out what part might be causing the issue. That comment block provides us no context, chances are there's a problem with the structure of the code in the file but we're unable to see the code to provide help.

Consider using the Improve question button and add more code (specifically some code around line 558) so we can properly assist.

Chris Copeland 9-Feb-22 9:28am View

Space in what way? Are you talking about padding, margins, or just the distance between the label and the input?

You're using a row and then col-md-2 and col-md-10 which means that the label is going to take up 16.66% of the space on the left while the input will take up 83.33% of the space on the right. You can change col-md-2 to col-md-1 to reduce the width of the label, and change the col-md-10 to reduce the width of the input.

Edit I also recommend you look at the Bootstrap documentation to get an idea of how to use it. This is the second question you've posted related to Bootstrap, and the documentation will provide most of the answers for you.

Chris Copeland 7-Feb-22 4:26am View

I don't know what that means (and yikes this is an old question!), I'm not sure what you're after if creating the C# code isn't enough? Again, a very quick Google found me this GitHub repository but I'm not sure if that's what you're after?

Chris Copeland 3-Feb-22 6:05am View

I've created a JS Fiddle and added some comments in there to describe the process.

Essentially we get a reference to the <select> element, then get the selected option and we can use that option to build the URL.

Chris Copeland 2-Feb-22 8:21am View

I've provided you with a JS Fiddle which will let you dynamically create textareas, each bound to clicking a certain element, you can use that as a template for creating your own system.

If having textareas generated per-click isn't what you're after then you'll need to come up with an alternate solution. If you have just one textarea on the screen and you're toggling visibility of it, then of course it will just display the previously entered content each time.

You either need to take the content from the textarea when it's hidden each time and do something with it (submit it via AJAX or store it in a JS variable), or you need to create new textareas with each click.

Chris Copeland 27-Jan-22 6:30am View

By API Gateway are you referring to AWS API Gateway? If so, that service provides an entry point for routing API calls to a load balancer and eventually a backing API, you wouldn't be expected to pass SQL queries to any API setup like that?

AWS RDS is a service which provides database connectivity, if you're using an API you'll need to refer to the documentation for that API. All API gateway setups have a public URL which is accessible for making the calls.

Chris Copeland 18-Jan-22 4:25am View

Just out of curiosity, what isn't working in the above? I pasted this code into .NET Fiddle and, aside from having to change the Solution class to public, it was working exactly as intended?

Chris Copeland 17-Jan-22 17:18pm View

You might need to use the developer console in your browser to debug the code. You can set a breakpoint in your script and step through the code to see what happens. It sounds like your Javascript isn't able to find the element in the parent window.

You could also try window.top.document.getElementsByName() instead?

Chris Copeland 17-Jan-22 8:06am View

I've answered this question on the previous question you submitted a while ago:

How to check an element exists in a parent window using javascript

Chris Copeland 17-Jan-22 8:04am View

The getElementsByName produces a nodeList which is one or more elements. In order to change the value you'll need to get the first element in the list, then update the value directly, like so:

const elements = window.parent.document.getElementsByName("txtfolio");
const target = elements[0]; // This is the first match
target.value = "Hello world!";

Chris Copeland 13-Jan-22 7:49am View

You never specified in your question that you were not interested in using third-party libraries, I just provided you with an alternative solution, not sure why it warranted down-voting.

In any case, your original question seemed to be asking for a complete solution, which isn't something that we provide here. We can assist with issues you're having on code you've already started, or we can provide guidance on how to accomplish something.

As you mention, you've already got your answer from another site so my proposed solution is redundant anyway.

Chris Copeland 13-Jan-22 6:32am View

If the files have difference sizes and contain the raw SQL that has been exported, have you tried opening the files and seeing what the difference is? Is one exporting CREATE statements while the other is only exporting data? If you actually look at the two files you should get a clearer picture of the difference between them.

You could also use a tool like WinMerge to compare the file contents.

Chris Copeland 12-Jan-22 4:59am View

Just out of curiosity, why are you doing a LIKE on two dates which have been formatted to match specific strings? If both the DateCreated and the datepicker1.ToString("yyyy-MM-dd") are both formatted to '%Y-%m-%d' then the LIKE and the % symbols won't do anything.

Chris Copeland 10-Jan-22 4:22am View

I won't post this as a solution as I'm not 100% on ASP, but I don't think the delegate keyword is meant to be used like that. Can you try removing the keyword and the parenthesis and try this:

@Html.DevExpress().RichEdit(setting =>
{
settings.Name = "RichEdit";
settings.CallbackRouteValues = new { Controller = "Home", Action = "RichEditPartial" };
}).GetHtml()

Chris Copeland 7-Jan-22 9:45am View

Have you tried opening the developer console in your browser and checked to see whether any errors have been produced? If the form isn't being generated then there must be something not working, by checking the console you can check if the JS has an error somewhere, or if the AJAX request wasn't able to access the JSON file.

I think one thing to note, potentially, is that AJAX doesn't play well if you just open a HTML file from file explorer. Browsers generally have strict rules around accessing files on the local computer, so it could be that your browser is blocking the request. Again, check the console to see what the issue is :)

Chris Copeland 7-Jan-22 6:26am View

I would think any effort to try and combine regular expressions would require an immensely complicated piece of code. Once you start considering lookaheads, back references and relative backreferences, things would get extremely tricky!

Chris Copeland 7-Jan-22 5:07am View

The code for what you've tried seems incomplete, it's correct to use an XMLHttpRequest but the code example you've provided is just invalid so it's impossible to work out what your issue is.

Also, what is the issue? You've provided what seems like requirements (for homework?) but not actually told us the problem you're having. Are you getting errors? Is something not loading?

Chris Copeland 6-Jan-22 5:21am View

I've updated my solution to include more information. It's quite common in programming to keep track of the states of things in variables, and in this case we can check the value of the myVar variable to see whether we need to start/stop the timer.

Chris Copeland 6-Jan-22 5:06am View

I'm not 100% sure what you mean. The parameters passed into a function can be constant values (like 1, 2, "Hello") or from variables. You can update variables by simply assigning them elsewhere.

You can add more variables for global state tracking by declaring them in the <script> tags. You can create functions which can be called, ie:

function doSomething() {
..
}

onclick="doSomething()"

If this isn't what you meant then please do provide more info and I'll help where I can :)

Chris Copeland 20-Dec-21 6:26am View

It sounds like you need to consult the documentation on the API. I think many REST APIs support some sort of "maximum results" parameter, it'd be down to whatever API you're calling. They might use paging, in which case you can make repeat API calls until you receive a page that has no results.

Chris Copeland 17-Dec-21 5:46am View

It sounds like you have a memory leak in your code somewhere. A memory leak is when you're loading a resource which consumes memory, but you're not adequately disposing of the resource when it's no longer needed. This winds up consuming more and more memory, so you'll need to run some diagnostics to work out what object(s) are the problem.

Analyze memory usage (you can change your VS version to match)

Chris Copeland 13-Dec-21 11:20am View

Presumably yes if that's where your distributor code is being stored, that would be how to output it. Just be careful in case your distributor code somehow ended up with single or double quotation marks, you might need to use addslashes() to escape them.

Also be very careful that the distributor codes you're talking about cannot be manually input by users. Someone could maliciously add extra data which would break the script and run JS code unintentionally 😊

Chris Copeland 13-Dec-21 8:26am View

What is the issue you're having? Are you seeing an exception, and if so what is the exception telling you is the issue? We can't know what the exact error is just by looking at this code.

Chris Copeland 10-Dec-21 4:48am View

It might have been nice to accept my solution given that this is exactly what I told you to do, I don't see why this needed to be posted as a separate solution?

Chris Copeland 9-Dec-21 5:04am View

This might be an issue instead with PHP creating a temporary file on your file system when the file is uploaded. PHP would normally consume the upload and store it as a temporary file somewhere so it can be accessed (via the 'tmp_name' property). Have you tried checking the $_FILES['file']['error'] property to see if it contains more information?

$_FILES error messages

Chris Copeland 8-Dec-21 9:26am View

I'm not even sure this is valid HTML, if you look at the actual element:

<a href='mail/afwijzingordermail.php?id="<?php echo $row['order_id']; ?>"' method="post">

It's a link with a method? That doesn't work, the method attribute is meant to be used with <form> elements. Also the link looks malformed, there's some double-quotation marks in there. I'm not sure if PHP would strip that out or not..

Chris Copeland 7-Dec-21 8:53am View

What values are being passed in to $_GET['idList']? Is it a string value delimited by something like commas or new-lines?

Chris Copeland 7-Dec-21 8:10am View

No problem 😊

Chris Copeland 7-Dec-21 6:09am View

It's really difficult to diagnose issues with this code because there's so much that we're not able to see. We don't know what the structure of the data variable is in your onQuerySuccess method, ~~and you have lots of references to elements such as ".reports-list-item--compendium" that we have no visibility of.~~ nevermind, just noticed you attached a JS fiddle. Still, that's a lot of code to ask people to go through.

Instead of taking large sections of your code and asking why part of it doesn't work, have you tried thinking about what you're attempting to accomplish and then building a smaller, less complex and easier to debug version? And have you been debugging your code, stepping through line-by-line, to examine what happens at each stage of the process?

Chris Copeland 3-Dec-21 10:03am View

You shouldn't have posted this as a solution but instead used the "Improve question" on your original question.

Chris Copeland 3-Dec-21 8:29am View

It's kind of hard to diagnose what might not be working because we don't know the structure of your HTML. What is '.timeline-compendium__content'?

Chris Copeland 3-Dec-21 5:18am View

What steps have you taken to debug this code? "does not work" isn't enough for us to go on, you need to use your browser's developer tools to inspect and debug the Javascript code, and use your PHP IDE to debug the PHP code to give us a clearer idea of the issue.

Is the JS producing a 400/500 response back? Is the PHP code failing at a certain point? It's hard for us to tell by just looking at the example you've given.

Chris Copeland 24-Nov-21 11:17am View

That's not a lot to go on, what part of your code is still assuming that there's a session active?

That being said, if you take a look at the session_destroy() documentation I don't think calling session_destroy() is enough. The documentation says that it won't unset global variables, and they provide an example (see Example #1) for completely removing all session data.

Chris Copeland 22-Nov-21 8:29am View

C# convert bool to string which should lead you to Boolean.ToString().

Chris Copeland 22-Nov-21 8:22am View

You've also not provided complete code. If the issue is in model.BVMS_PMON = data.BIW; then you've not given us any code to tell us what this model variable is. Is it a class? We can't see what the BVMS_PMON property is but if I was to guess it's going to be a string, and you cannot assign a bool to a string without converting it.

Chris Copeland 22-Nov-21 8:19am View

Again, you need to debug your Javascript code to see what happens when it runs. This means putting in breakpoints and stepping through the code to see what happens. Without any errors visible in the console, you're reliant on debugging the code.

Debugging in Chrome
Debugging in Firefox
Debugging in Edge

It's important to get used to debugging code because this will be your primary way of testing and analysing code when it's not working correctly. Every good developer will switch to debugging when their code isn't working as intended.

Chris Copeland 22-Nov-21 6:43am View

If your console is not producing an error message (which it should do if some part of the script is not working properly) then you may need to debug your Javascript and step through the code line-by-line and see what isn't working.

For example, it may be failing to load the Q1.xml file. In your switch(xmlReq.readyState) block you only return if the ready state is something unexpected. Also, you haven't got an error event handler setup:

xmlReq.addEventListener('error', function (e) {
  console.log('An error occurred!');
});

At this stage on you can debug and identify what error is being produced. If you can provide us with information about the error, we might be able to provide some support.

Chris Copeland 22-Nov-21 4:20am View

Yes Javascript routing can detect the path of the URL when the page is loaded, so having something like /view/episode-1-some-title/ would be loaded correctly.

I suppose the main benefit of this is distribution and sharing? Imagine if someone opened a product page and wanted to share it with their friends or partner as a suggested present for Christmas, they will typically take the URL from the browser and send it across. Without this functionality in the URL, they'd have to give detailed instructions to find the correct page. And if they wanted to bookmark the page, well that would be impossible if the URL wasn't constructed properly.

Search engines also struggle a little bit at the moment with SPAs, though they're making best efforts to try and improve their indexing engines. If the entire application was locked behind button presses however, that would become impossible to index.

Chris Copeland 19-Nov-21 4:58am View

You're welcome! 😊

Chris Copeland 15-Nov-21 12:18pm View

You'll need to amend either the API endpoint to correctly produce the result you're expecting (we can't see this code, you haven't included it, you can always edit your original question by using the Improve Question button) or amend your Javascript to correctly consume the data.

As I said, your Javascript is expecting a JSON object in the response body, but you can see from the console.log() line that it's producing a JSON array instead. Either your Javascript is wrong or the result returned from the API endpoint is wrong, you need to assess which is the correct result.

Chris Copeland 15-Nov-21 11:47am View

This sounds more like the API isn't producing the output that you expect, rather than an issue with this piece of code in particular. You might need to look at the documentation for the API endpoint and see why it's producing an incompatible response.

Your code is expecting a JSON object back with properties such as 'dnum', 'num' but you can clearly see the actual response out is a JSON array of objects.

Chris Copeland 11-Nov-21 4:13am View

You've provided an example of a JSON payload, is this how it's stored in the PHP? If it's stored as a string you'll need to use json_decode() which takes a JSON string and converts it into an object. Then you can access the properties of the JSON accordingly.

Also remember that this JSON decoded would be an object so you need to reference the properties of said object. Ie. $object->data->orders->order

Chris Copeland 22-Oct-21 4:49am View

What do you mean "display the result of this code"? This is the code for a PHP file so you'd need to run it through a PHP webserver, such as XAMPP

Chris Copeland 15-Oct-21 5:12am View

If this is where the problem exists then it sounds like PHP isn't able to decode the JSON content correctly, have you tried printing out the value of $data to inspect what the content looks like?

var_dump($data);

Chris Copeland 13-Oct-21 6:27am View

You haven't told us what's wrong with the code. What error(s) are you encountering, what part of the code isn't working as intended?

Also your code seems to have two Main() methods which is odd, have you just copied and pasted multiple files into one big block?

Chris Copeland 13-Oct-21 6:24am View

That's your problem, you're trying to mix and match the PDO class (which I would say is probably a better choice to use) with the sqlsrv_ methods. In order to establish a connection for sqlsrv_query() you have to use sqlsrv_connect()

If you want to use PDO instead then that's fine, you'll have to use the PDO-specific methods such as PDO::query

Chris Copeland 13-Oct-21 5:43am View

It's hard to diagnose this without knowing what's in the conn.php file, but it sounds like the $conn variable isn't being initialised as a database connection. Check that the $conn variable is actually being assigned from sqlsrv_connect(), and possibly provide the contents here (with any credentials removed)

Chris Copeland 8-Oct-21 9:55am View

You had code on here previously and now you've removed it, why? Providing us with code gives us some context where we can provide advice, without it we can't know what you have and haven't tried.

Chris Copeland 5-Oct-21 6:05am View

This isn't a very clear request. Is the output that you've provided what you expect the produced content to be, or is it what is currently being produced? Also, what do the numbers in parenthesis mean?

You can already store the result of that function in one variable: var value = sum(1234);

Chris Copeland 5-Oct-21 5:04am View

What seems to be the issue? Is it that the click event isn't being raised, or that you don't understand how to dynamically add the content to the downloadFile() method?

Also, how come you're binding a click event handler to the li element? Does the myFunction() function actually exist?

Chris Copeland 4-Oct-21 8:24am View

I think you need to do some research into WPF + data binding + observable collections. You would update your main view-model "Items" property to be an ObservableCollection<copycloneviewmodel>, this will add the automatic binding so when an item is added to the collection the visual tree gets refreshed and renders the new items.

You would add your new string property to the CopyCloneViewModel (since that is the object that is being rendered at that level of the tree), and bind the TextBox Text property to the new string property within your child control.

So think of it like this: your main view-model has the collection of CopyCloneViewModels, each of which has a text property. Then in your XAML you're creating a child control for each one of these view-models (correct), and then in your child control you'll bind your TextBox.Text property to the text property in the CopyCloneViewModel.

Chris Copeland 4-Oct-21 7:02am View

You still haven't closed the $(document).ready() block correctly. The }); at the end of your script block is closing the $.ajax call, but the parent $(document).ready() still needs to be closed.

Chris Copeland 4-Oct-21 6:49am View

Your code still isn't correct, you've not closed the $(document).ready() block. If you look at the code you can see that you're missing the }); which would close that function call, and you have a closing } below your script closing tag.

Chris Copeland 4-Oct-21 5:04am View

Can you elaborate on "I have a few problems there too"? If you can explain what is and isn't working then we can provide suggestions.

Chris Copeland 21-Sep-21 10:29am View

I think this might be that troll user again.

"I am not debating here IF it's worse or the same because I believe it simply doesn't matter but if it makes any profitable difference which I am closer to think it does not. I have found several articles that confirms it so far."

If you've found several articles (and therefore done your homework already) why are you asking questions here? Are you purposefully just trying to catch people out and call them out?

Chris Copeland 14-Sep-21 4:12am View

If you're positive that the response status is okay but Sendgrid isn't showing any activity on the account then you need to raise a support ticket with Sendgrid. I'm not completely convinced that you've been looking at the correct Sendgrid account and/or looked at all the different areas to find the issue. But maybe raising a Sendgrid support ticket should get you some answers hopefully. I can offer no solution.

Chris Copeland 13-Sep-21 8:22am View

So there's absolutely nothing in Sendgrid to indicate that it attempted to generate the email, and send it to the email address? And yet your code doesn't produce any errors and it has a response status code of accepted?

Something doesn't add up, either the API is producing an invalid response, or there should be something in Sendgrid to indicate what went wrong. If neither is true then you'll need to raise a support ticket with the Sendgrid team to have them investigate.

Are you sure you've debugged your code and the "response.StatusCode" is accepted?

Chris Copeland 13-Sep-21 6:28am View

If the status code is accepted then there could be many causes for the email not to go through. I would suggest (having used Sendgrid myself in the past) to login to Sendgrid and check the activities to see whether it has marked the email as having been sent. See whether Sendgrid is reporting any problems with finding and/or populating the email template, and whether the delivery status of the email is confirmed.

Chris Copeland 13-Sep-21 4:12am View

So what is happening exactly? Is the code throwing an exception; if so, what does the exception tell you is wrong? Is the call to "SendEmailAsync" returning a response with a status code that isn't accepted; if so, what is the status code, have you looked at the documentation to see what it means?

You need to provide us with more context than "Email not send", use your debugger to step through and inspect your code to work out what errors is bring produced, then you can start to work on a solution.

Chris Copeland 10-Sep-21 5:00am View

The responsibility of debugging and working that out relies on you - the developer - to do, and it'll be good to practise doing it. A large part of development is things not working and having to take the time to debug and work out why not.

That being said, the fact that your error is reporting $ is not defined tells me you perhaps haven't included jQuery as a dependency on your page? I don't understand why you're using a combination of both vanilla JS and then the one single line of jQuery?

Chris Copeland 6-Sep-21 6:46am View

Deleted

One thing that might be worth looking into is:

You've set your method to "GET", but you use the $_POST variable in your PHP code. Since you've set the method to "GET" you'd need to instead look at the $_GET variable.

Chris Copeland 11-Aug-21 6:40am View

I agree with TheRealSteveJudge, making a website responsive without leveraging an existing framework is going to be quite a challenge. You're going to need exhaustive knowledge of media query selectors, something which you've not used in the CSS you've provided.

This page has some documentation on the use of media selectors

Chris Copeland 10-Aug-21 4:09am View

You won't be able to connect directly via an ARN because your ODBC connectors don't understand how to translate the ARN descriptor into a connection string. Instead you are going to need the database address. You need to speak to your DevOps team and explain the situation and ask for all the information needed to establish an ODBC connection to the database.

Chris Copeland 5-Aug-21 11:26am View

This is a repost of this question you asked already, please don't repost the same questions but instead review the solutions already provided to you.

Chris Copeland 5-Aug-21 10:18am View

I can't immediately see a problem with this code, how are you binding the ViewModel to the Window itself? And are you using the ComboBox within a template or style? Have you confirmed that the query is loading values from the database, ie. check with a debugger to step through the code?

I will note that the ComboBox isn't provided with a DisplayMemberPath so it will probably try to call ToString() on each of the objects in the collection.

Chris Copeland 5-Aug-21 6:02am View

You need to do some research into regular expressions and understand how they work. A good starting point would be to look at "anchors" (which can be used to detect the start and end of a string), and "alternation" (which can be used to check for combinations of options)

/^hello/g checks that the string starts with the word "hello", while /world$/g checks that the string ends with the word "world"

/(hello|world)/g checks that the string contains either the word "hello" or "world"

Chris Copeland 4-Aug-21 10:55am View

That explains it then, that version of PHP does not have the "get_magic_quotes_gpc" method, so you need to upgrade the version of Wordpress that's running to one that doesn't use that method. The alternative is to downgrade your PHP version back to 7.

Chris Copeland 4-Aug-21 8:22am View

There's not enough context here to work out what it is you're actually trying to accomplish. You've populated a combo-box with weekdays, but what's the calculation for total hours? If you mean hours in the day then it would be 24 * the number of selected items?

Chris Copeland 4-Aug-21 8:18am View

Also worth noting that this Wordpress page explains that the function should have been fixed.

Chris Copeland 3-Aug-21 4:14am View

You are very welcome :)

Chris Copeland 2-Aug-21 4:11am View

What isn't working with the code you've provided? We need some context on whether you're receiving an error, or whether it's just not behaving as you would expect. We can't see what happens on your screen when you run this code, so we can't know what the output of running it is!

Chris Copeland 27-Jul-21 9:49am View

Following up on this after some thought, if you also want to protect the user from malicious actors accessing the cookies or local storage to see their purchase history, you could also use a JWT token to make things secure. Upon checkout generate a JWT token and store the purchase information in the database against the token, and send the token back to the browser to be stored in a cookie or local storage.

Upon registration, accept the JWT token as part of the submit process, and then look-up whether any purchases were made. This is far more secure because the JWT token does not expose the purchase information directly, and are incredibly difficult to forge. Some JWT tokens also allow you to use a signing key to encrypt and decrypt the contents, so you can even store the purchase information within the token and omit the database component altogether.

Chris Copeland 27-Jul-21 5:55am View

The reason NuGet exists is to try and resolve some of these referencing hellscapes. With NuGet packages you can clearly and distinctly provide all referenced dependencies, however with Project References you're dependent on the linker to work everything out. The release mode builds are notorious for optimizing out code and dependencies it doesn't think are being used, even if they are (imagine trying to reflectively load an assembly but the build removes it as being unused!)

Comments by Chris Copeland (Top 200 by date)