• Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Access Database online through VB.net?

    IIRC an OLEDB connection string to a MS Access database uses a filepath/UNC path. This is not possible over an open internet connection. You'd need to build an API around …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How do you handle your CAPTCHA?

    Using 2FA so it can be used with Authy on my phone.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Start new topic bug

    Not a problem for me.
  • Member Avatar for pritaeas
    pritaeas

    Marked Solved Status for Start new topic bug

    I started my previous question with the title "Filter by" . I typed my question, clicked go to the next step. After that I clicked "Free" and only after that …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Filter by annoyance

    What I'm only looking for is that when I go to the Programming Forum for example, the recommended filter is on. I want that if I turn that off, that …
  • Member Avatar for pritaeas
    pritaeas

    Created Start new topic bug

    I started my previous question with the title "Filter by" . I typed my question, clicked go to the next step. After that I clicked "Free" and only after that …
  • Member Avatar for pritaeas
    pritaeas

    Created Filter by annoyance

    The "filter by" at the top of a forum is by default set to "recommended". I'd love to have it remember (at least for the duration of my session) that …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Bug in profile - Professional networking

    Confirmed.
  • Member Avatar for pritaeas
    pritaeas

    Marked Solved Status for Bug in profile - Professional networking

    I just updated my professional networking profile. The skills and interests textbox was prefilled with php, mysql, javascript, web-design and asp.net presumably from my post history. I've updated this to …
  • Member Avatar for pritaeas
    pritaeas

    Created Bug in profile - Professional networking

    I just updated my professional networking profile. The skills and interests textbox was prefilled with php, mysql, javascript, web-design and asp.net presumably from my post history. I've updated this to …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Notice: Undefined index: id_anggota in C:\xampp\

    You use `$_GET['ID']` while your form uses `method="POST"`
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in URGENT HELP ER Diagram

    What do you have so far?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in comments table has 3 records but it is only displaying one record

    $sql =" SELECT * FROM `comments` "; $result = mysqli_query($db, $sql); while($row = mysqli_fetch_assoc($result)) { $sql =" SELECT * FROM `waste_collection_companies_info_table` WHERE `company_id`='$comment_company_id'"; $result = mysqli_query($db, $sql); while($row = mysqli_fetch_assoc($result)) …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in jQuery .stop() all animation

    How about turning it off and on again? Turning it off would instantly stop all animations. Turning it back on will only start new animations, no?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Formatted Integer

    You might want to have a look at this: https://www.peterbe.com/plog/format-thousands-in-python
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in jQuery .stop() all animation

    https://api.jquery.com/stop/ > Animations may be stopped globally by setting the property `$.fx.off` to `true`. When this is done, all animation methods will immediately set elements to their final state when …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Variable onChange listener?

    Are you looking for this perhaps? https://docs.microsoft.com/en-us/dotnet/framework/winforms/how-to-implement-the-inotifypropertychanged-interface I don't have a working example for you, but there's lots to be found online.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in PHP + MySQL user defined function

    If you think it's the SQL, then add some error handling and find out: https://www.php.net/mysqli_error
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Create Infinite Loop In Bash

    Why not use `cron`: https://opensource.com/article/17/11/how-use-cron-linux
  • Member Avatar for pritaeas
    pritaeas

    Gave Reputation to nishita_1 in mysql query for sum two table data

    please any one help me
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in New homepage and more changes

    Much better IMHO. Good job.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in mysql query for sum two table data

    Probably something like this: SELECT * FROM ( SELECT product_id, SUM(quantity) AS purchase FROM purchase GROUP BY product_id ) P JOIN ( SELECT product_id, SUM(quantity) AS sale FROM sale GROUP …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in if exists, update, if not insert

    If `cu_client_id` is your PK then you can use: https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in oledbexception was unhandled (too many fields defined)

    1000? Do you need all of them? Apart from the adapter not loading them, this will become a huge performance hit.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Are you coding from home during this pandemic?

    Yep, forced to work at home.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Parse error: syntax error, unexpected 'if' (T_IF) ine 5

    Remove the `ìf`s from lines 4-8
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Covid-19 Virus and N95

    If you have the symptoms, you cannot visit your own physician. If you think you are infected tests will have to show so. Regional/national health institute has to do that, …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Notice: A non well formed numeric value encountered in ..

    https://www.php.net/manual/en/function.password-hash.php The second parameter denotes the algorithm to use, so why are you adding microtime() ??
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Covid-19 Virus and N95

    Jim asked what the situation here is. I live in the dutch region with the most issues. Companies are requested to let people work at home as much as possible. …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Help supplying 0 when ISNULL

    Have you tried COALESCE instead of ISNULL ?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Grouping a collection based on ID using Linq c#

    Here's something I put together. Not sure how it matches your situation. If you have additional questions/problems, please ask. void Main() { string json = "[{" + "\"id\": 116," + …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Grouping a collection based on ID using Linq c#

    If you do a GroupBy on the properties amgId and amgName then you can fill the prodQty array. If you can provide a small working example I can work with, …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in oledbexception was unhandled (too many fields defined)

    How many columns are defined in your table?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How can I optimize images on my site?

    Wondering why nobody has mentioned [webp](https://developers.google.com/speed/webp)?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in With no limitations from the client, what is your build stack?

    Custom built .NET Core application on Azure
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Scheduled Job Sql Server

    > could you please tell me what a job is A job is like a task, to run at a certain time/interval and consist of one or more steps. > …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in parsing xml document

    That would make more sense.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in parsing xml document

    You can only read it if it originates from the same domain. Same origin policy prohibits reading iframe source from a different domain.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Help with Windows Service

    I'm wondering why you set the service status explicitly? If you have created a windows service app from Visual Studio, those should be set automatically. While a Timer is great …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Why is this code wrong? http://localhost/testing_programs_1.19.20/index.php

    Define "wrong". What is it supposed to do, and what part doesn't work, any errors perhaps?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Working with dates in Windows Forms - C#

    Have missed the AD/BC requirement, wonder why he needs it...
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Working with dates in Windows Forms - C#

    You can use `DateTime.Parse()` to convert your string to a `DateTime`. `DateTime` variables can be subtracted resulting in a `TimeSpan` containing the difference.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Programs don’t even ask where you’d like to install these days

    https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/mklink In some cases the following works: I created a new folder with the same name on my HDD, moved the files and created a junction on the SSD.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Trying to get username to display in the url

    echo '<a href="profile.php?user="'.$usersUsername.'">'.$usersUsername.'</a><br>'; should be: echo '<a href="profile.php?user='.$usersUsername.'">'.$usersUsername.'</a><br>'; // removed one double-quote
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in cross verify existance of sub folders from 1 director to another

    Have a look at robocopy to do this for you: https://social.technet.microsoft.com/Forums/lync/en-US/0b3d3006-0e0f-4c95-9e2f-4c820832ebfa/using-robocopy-to-copy-folder-structure-only?forum=w7itprogeneral
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to make function give row that have different value with color red ?

    Here's something to start with: $(function() { $("table tr").each(function() { var tdValues = []; $(this).children().each(function() { tdValues.push($(this).text()); }); // here you can use tdValues to check whether the values contain …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Hi, I'm Abdulrahman_2

    Welcome.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Hello Everyone ....!!

    Welcome.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Insert data in sql server 2012 using php pdo

    > $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); He asked for Microsoft SQL Server, not MySQL
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to update a column using ID in phpmysqli?

    Why are you mixing the OOP variant of mysqli on lines 15-21 with the procedural variant on line 38 ??

The End.