Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. spamjim

    stepping through table rows

    Yes, you are overlooking something simple. When you run UPDATE, it automatically steps through each row if you have not limited the statement or added a condition that restricts the update to one row. It may help to further explain your intended update.
  2. spamjim

    Body of email not appearing in correct font on iPhone and iPad

    There's nothing in your HTML that includes the Verdana font. The HTML only suggests the Verdana font if it is installed on the system. If the system does not have Verdana, it falls back to any sans-serif font. Verdana is typically installed with Microsoft applications, such as Office. You may...
  3. spamjim

    Sanitizing illegal filenames on NTFS volumes

    Adding another option if one cannot go back to the Linux or Mac system... On Windows, you can use the free version of Recuva, a file restoration utility. One of the features of this program is to sanitize filenames while copying from a "bad" drive to a good drive. In the Recuva preferences...
  4. spamjim

    Sanitizing illegal filenames on NTFS volumes

    I've apparently never crafted the proper google query in the past 25 years that I've fought this issue. It looks like I can resolve this with detox. https://linux.die.net/man/1/detox
  5. spamjim

    Sanitizing illegal filenames on NTFS volumes

    I have a few USB portable NTFS drives that have also been used on Mac and Linux systems, via fuse and other native OS accommodations. When I reconnect a portable drive to a Windows system, I discover that the Mac and Linux systems did not fully follow the rules for NTFS filenames. While copying...
  6. spamjim

    Dropdown list data generator

    Why would your teacher give this assignment without teaching how to do it?
  7. spamjim

    My website refreshes twice when it is opened on any browser.

    It loads once in my browser because I have JS turned off for unfamiliar web sites. Examine your JS. You can also us the network tab in your browser's developer tools (F12) to see what's happening.
  8. spamjim

    Formatting Full Hard Drive

    There is the additional benefit of accessing this second drive on a system that isn't actively trying to back up more data to it. Running an alternative OS (through this live USB) or taking the second hard drive to another computer offers many opportunities.
  9. spamjim

    whats wrong with Vlookup

    I'm not following either example file. You might try sharing 3 rows that show sample source data and then enter example values in columns K, L for what you want to obtain from a vlookup. If you have 11 rows of data, your vlookup in L2 might be "=VLOOKUP(H2,$D$2:$I$12,6,FALSE)" ...but even...
  10. spamjim

    Can't sort my table by a particular column, records are returned in autinc order.

    You are probably bumping into a conflict with a reserved word ("name"): https://dev.mysql.com/doc/refman/8.0/en/keywords.html Employ the backtick: ` Instead of: $queryResult = $g_dbFindATradie->query("SELECT id, name, description FROM trades ORDER BY name"); Try: $queryResult =...
  11. spamjim

    Risk of running unsupported server version

    While it may not be exposed on the internet, its local connection to other computers could invite exploit. How trustworthy are those other systems? Can ransomware spread from those other systems?
  12. spamjim

    Adobe Acrobat Fillable Form with Checkbox and Values

    This forum is barely trafficked. You will probably get better feedback on Adobe's user forums. As a general tip, it is best to avoid PDF forms for data collection. Most people really want web-based forms, even if they don't realize it yet. A web based form can better manage data and may even...
  13. spamjim

    Join two mysql tables for populate datatable

    Great! Now you can take it a step further by using prepared statements (or other data sanitation methods) to avoid SQL injection.
  14. spamjim

    Join two mysql tables for populate datatable

    Focus on the query, not the PHP. There's even a Tek-Tips forum to focus on MySQL. [bigsmile] https://www.mysqltutorial.org/mysql-left-join.aspx SELECT `order_id`, `customer_id`, `order_item`, `order_date`, `order_value`, `customer_name` FROM `tbl_order_id` LEFT JOIN `customers` ON...
  15. spamjim

    DVD Player - FREE (keyboard shortcuts)

    My DVD player on Windows 11 uses the very same keyboard shortcuts I use in VLC media player, and on any other platform. It makes it very convenient that I don't need to remember different sets of shortcuts when I am on different computers. https://wiki.videolan.org/QtHotkeys/ If this was not...
  16. spamjim

    HTML/CSS Image map with multiple tool-tips

    There are still many ways to style the tooltip presentation (example). However, as many people use touch devices now, the hover action is not typically worth the development investment. A JS action on click/touch would be better.
  17. spamjim

    HTML/CSS Image map with multiple tool-tips

    Beware that hover actions may be an accessibility issue with users of devices that do not hover (tablets). You could add a title to the area tags (title="Janet"). <span class="tooltip"> <area shape="POLY"...
  18. spamjim

    File on memory card

    The lack of a modified date suggests a filesystem corruption. Some of the reasons that can happen: if the media is not formatted ideally for your device...if your device ran out of battery juice while it was recording video and failed to properly complete a disk write...and a dozen other...
  19. spamjim

    Clarifiy version and licensing issues

    Skip, that's more of a vendor lock-in situation and a lack of competition than a matter of employees needing any advanced exclusive features of Excel. While this topic has had a slight detour on the merits of Excel, the real licensing issue at hand is that these office applications have mostly...
  20. spamjim

    Clarifiy version and licensing issues

    Understood and agreed. Those features are valuable for advanced users, like this web site's audience. However, this limited survey suggests only 6% use VBA. If those 6% had access to a report/SQL server to better manage their data, that percentage might be even lower.

Part and Inventory Search

Back
Top