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 gkittelson 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. 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," & _ "...
  2. KMinor

    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...
  3. KMinor

    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"]."%'");

Part and Inventory Search

Back
Top