No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | More like general MySQL than vb.net itself, but still need help. The MySQL code below: [CODE] SELECT * FROM (SELECT resit_no,SUBSTRING(resit_time,1,19) AS entrystamp FROM DB1.receiptdetails WHERE terminal LIKE '%99' AND resitdate BETWEEN '2010-12-01' AND '2011-01-31' AND productcode BETWEEN '91000001' AND '91000009') res1, (SELECT expdate_resitno, SUBSTRING(TimeModified,1,19) AS moded_time FROM DB2.mtransactionstatus WHERE … |
| | Hi, I have this question about how to retrieve a column with DateTime from MySQL as String and put the data in a textbox. :| So I've been using something like this... [CODE]Private Function check_ResitDate_ResitNumber() Dim SQLquery As String Dim rrnRD As OdbcDataReader Dim DiTi As DateTime SQLquery = "SELECT … |
| | Hello, codegurus. Excuse me, but I need help. I have been assigned to deploy a system that uses VB.Net and MySQL. After testing on 9 different PCs each on different regions, only 1 PC shows this error during deployment: [CODE]System.ArgumentException: Formatof the initialization string does not conform to specification starting … |
| | Hello again, codegurus. I need to ask your assistance in converting string to datetype, from 'dd/mm/yyyy' to 'yyyy-mm-dd'. The user could key in either the 'dd/mm/yyyy' format or 'yyyy-mm-dd' format in a textbox. the system would check for both format and convert both to the 'yyyy-mm-dd' date format, to be … |
| | Dear Codegurus, [B]How do I updatezz data from 2 rows to 2 columns?[/B] tool: vb.net server: MySQL (SQLyog) I have 2 tables, membercardlist and memberinfo: table membercardlist: [CODE] ------------- ------------ ------------ | AccountNo | CardNo | status | ------------- ------------ ------------ | 9999 | B009 | inactive | ------------- ------------ … |