Comments by Cody O'Meara (Top 31 by date)

Removing the "deploymentProvider" snippet from the .application file wasn't working. Also in the publish Wizard having the do not update option was not enough when republishing. I went to Solution Properties > Publish > Updates and under "Update location", I cleared out the location to be blank and was able to successfully install. Thank you both for the help.

Perfect, thank you! One thing I will also try tomorrow is deploying it from another workstation that has VS2022 installed and see if it publishes the same way. Thanks again!

I adjusted the question. The "completed" was referencing that the app is complete but failed to install on the clients machine. The published solution and client are on two different machines.

In VS, I went to "Build > Publish [app name]"
On the first screen in Publish Wizard, I "Browsed" to the network location that our other deployments are on. Normally at this point I would just click "Finish". But when I do go through, the "From a CD-ROM or DVD-ROM" option is selected and "The application will not check for updates" is also selected.

Thank you for your answer! However the control isn't in the .NET Framework Components tab under Choose items. Also when looking under the Add or Remove Programs, I don't see anything related to the Report Viewer. Even though its a pain, I think I'm going to try uninstalling my environment and start fresh.

This works perfectly, Thank you very much!

Thank you for the response! Tried it and unfortunately it results in the same thing.

I will definitely check out Hangfire!

Unfortunately, the documentation from what I found did not explain how install/configure it as it was more of how to use.

And from what I did find on how to install from other sources, the results were not the same on my side.

Thanks Chris! This is very well explained and gives me a starting point to research further.

Thank you. This was one of the moments where I was working for around 12 hours straight, it was the end of the night and when you cant figure out the easy solution like this, its time to go to bed. haha! All set :D

Works perfectly! Thank you

Eventually figured it out and that was it! Thanks!

Thanks for your reply Dave! I actually did end up going with the DGV. Not sure why it took me a bit to realize that would be better!

https://gyazo.com/1ece30bfcf0685df7317d01a7fefb3bb

Here is a link to show my 2 tables. The ones highlighted should be displayed as they are not in the fullName table.

https://gyazo.com/66a84d81c7214cfc7d0dd9a41962bce0

Thank you for the response. Unfortunately I'm coming up with 0 results

a example:
Results table:
ABC 1999-05-28
ABCDEF 2020-05-28
Cody 1999-05-28

Employees table:
ABC
Cody
Ted
ABCDEF


After using the dateTime = CURDATE() which is 2020-05-28, I need it display

ABC
Cody
Ted

as there was no results submitted on the CURDATE(). Since ABCDEF in on the CURDATE() it does not need to display.

I guess I should add some background. At our place of work, every morning a user fills out a daily health assessment. We want to be able to see who did not fill out the assessment that day, just for reporting.

Thank you for your help! Unfortunately this doesn't seem to be working. For more of an explanation. In my 'employees' table, I have 100 records. In my 'results' table, I have 75 records(after the where 'dateTime' clause). I want to display the 25 records that is not in the table'

On the 'DateTime' subject, In my results table, I have 500+ records and about 75 added every day. The 'Datetime' filters it to only include today's results. Maybe I need to add where clause somewhere else?

Thanks again for your response!

Do you know of another solution to sort of getting to what I'm trying to do? Its only data so maybe it can read it from another file instead of querying it directly?

I would think there would be a way, how do businesses send emails with buttons, personal information, and what not?

Thanks for the reply!

So I eliminated the error by using \' as the quotes for some that was creating an issue. But now, I am having an issue around

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("SELECT fullName, result FROM results where dateTime > CURDATE() ");
$stmt->execute();

// set the resulting array to associative
$result = $stmt->setFetchMode(PDO::FETCH_ASSOC);

foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
echo $v;
}
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
$conn = null;
echo "";

Thank you for your response. I checked the syslog and everything looked good:
CMD (/usr/bin/php /var/www/html/tsl/email1.php)

Just for the heck of it, I deleted the line in the crontab. I reentered including the root and it is working now. Thank you so much!

Hello! Unfortunately I was unable to get it to work properly. I ended up doing something else. It wasn't as good as this could of been unfortunately.

I probably am missing something. I have this "totalRows = tabledgv.Rows.GetRowCount(DataGridViewElementStates.Visible) - 1" for getting total rows. It does work as I have a label that displays on load to which is correct amount. I also have this checker"If newNum > totalRows Then newNum = 1 End If" to reset back to the first row which there are 2 rows with data. Happens when trying the second row. This happens before the check to see if strCellValue equals nothing.

Thank you for the response. Correct. Inside the cell there is no value so I'm trying to get it to say "N/A" when there is nothing in the cell.

Thank you for the response RickZeeland. I change it. Now getting Suppression State
Error BC30020 'Is' operator does not accept operands of type 'Boolean'. Operands must be reference or nullable types.

Worked Perfectly. Thank you!