208 : select C.*, d.firstname, d.lastname, d.city, d.state, d.title
209 : from beforeaftercases c, dentists d
210 : where d.dentistid = c.dentistid and d.dentistID = #REReplace(url.dentistid, '[^0-9]+', '', 'all')#
211 : order by c.casedate asc
212 : </cfquery>
|
SQLSTATE |
42S02 |
DATASOURCE |
oogle_cc_aws |
VENDORERRORCODE |
1051 |
SQL |
select C.*, d.firstname, d.lastname, d.city, d.state, d.title
from beforeaftercases c, dentists d
where d.dentistid = c.dentistid and d.dentistID = 1184134995
order by c.casedate asc
|
|