|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 19th, 2005, 06:09 AM
|
||||
|
||||
|
query problem
hi.....
i m getting error when run this query..can we form such query?????? strSQL = "SELECT distinct y.company_id,y.company_name,z.location_id,z.locati on FROM appointment_detail AS x INNER JOIN company AS y ON x.company_id = y.company_id AND appointment_detail AS x INNER JOIN location_table AS Z ON x.location_id=z.location_id ORDER BY y.company_name,z.location" error//////////// Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''. /sd/jobsearchasp2.asp, line 18 can any suugestion....................thanx
|
|
#2
July 19th, 2005, 06:13 AM
|
||||
|
||||
|
Hi
access is very weird when it comes to inner joins try the following: Code:
strSQL = "SELECT distinct y.company_id,y.company_name,z.location_id,z.locati on FROM (appointment_detail AS x INNER JOIN company AS y ON x.company_id = y.company_id) INNER JOIN location_table AS Z ON x.location_id=z.location_id ORDER BY y.company_name,z.location" hope this helps
__________________
Look! Its a ShemZilla    
|
|
#5
July 19th, 2005, 06:44 AM
|
||||
|
||||
|
above query i want to add "appointment_detail.expiry_date >=date()" becuss i want those entries which date is greter then current date for sorting.
pls once again solve my problem i tried but getting error...... thanx
|
|
#7
July 19th, 2005, 06:48 AM
|
||||
|
||||
|
strSQL = "SELECT distinct z.location_id,z.location, y.company_id,y.company_name FROM (appointment_detail AS x INNER JOIN location_table AS z ON x.location_id = z.location_id) INNER JOIN company AS y ON x.company_id=y.company_id" & " AND appointment_detail.expiry_date >=now() ORDER BY z.location ,y.company_name" Microsoft OLE DB Provider for ODBC Driverserror '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. /sd/jobsearchasp2.asp, line 20
|
|
#8
July 19th, 2005, 06:50 AM
|
||||
|
||||
|
Hi,
you must use a WHERE clause try this: Code:
strSQL = "SELECT distinct z.location_id,z.location, y.company_id,y.company_name FROM (appointment_detail AS x INNER JOIN location_table AS z ON x.location_id = z.location_id) INNER JOIN company AS y ON x.company_id=y.company_id WHERE appointment_detail.expiry_date >=now() ORDER BY z.location ,y.company_name" hope this helps
|
|
#9
July 19th, 2005, 06:59 AM
|
||||
|
||||
|
still showing error............
Microsoft OLE DB Provider for ODBC Driverserror '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /sd/jobsearchasp2.asp, line 21
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
