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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by KMinor
-
SQL Order ascending
Can some one please tell me where to add this part: ORDER BY dbo_PAYROLLDB_EMP.ENAME asc into this sql statement: SQL1 = "SELECT DISTINCTROW dbo_PAYROLLDB_EMP.ENAME, dbo_PAYROLLDB_EMP.PAYGROUP," & _ " dbo_PAYROLLDB_EMP.STAT_CODE, dbo_PAYROLLDB_DEPT.DESCRIPT," & _ "...- KMinor
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Getting this error in VB6 - Please Help
Can someone please tell me why I keep getting this error when running this sql statement: Invalid syntax near '.'. SQL1 = "SELECT dbo.PAYROLLDB_EMP.ENAME, dbo.PAYROLLDB_EMP.DEPARTMENT, dbo.PAYROLLDB_JBDES.DESCRIPT" & _ "FROM dbo.PAYROLLDB_EMP INNER JOIN dbo.PAYROLLDB_JBDES ON...- KMinor
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
SQL Query
I am trying to write a MySQL query that has more than one WHERE statement using "or" .Can some one help? $result= mysql_query ("SELECT * FROM $tablename WHERE Social_Security $ LIKE'%".$HTTP_POST_VARS["name"]."%'");
