>- see footer for list info -< OK, I have been getting some really weird SQL errors on a site we just launched. Some examples are:-
(param 1) SELECT jobemployers_users_id RecruiterUserID, jobemployers_id RecruiterID, jobemployers_firstname FirstName, jobemployers_lastname LastName, jobemployers_email Email, jobemployers_username UserName, jobemployers_password Password, jobemployers_tel Telephone, jobemployers_fax Fax FROM tbl_JobEmployers_users WHERE jobemployers_id IN () Where some how my cfqueryparam has jumped out of the IN statement to the beginning. jobsSearchesID AS JobSearchID, jobsSearchuserID AS MyJobsUserID, jobsSearchCreatedDate AS CreatedDate, jobsSearchName AS Name,jobsSearchIsJobAlert AS IsJobAlert,jobsSearchLastRunDate AS LastRunDate, jobsSearchAlertLastSent AS AlertLastSent,jobsSearchTypesID AS JobSearchTypeID, jobsSearchPhrase AS SearchPhrase, jobsSearchPhraseType AS SearchPhraseType, jobsSearchSalaryMax AS SalaryMax, jobsSearchSalaryMin AS SalaryMin, jobsSearchMode AS Mode FROM tbl_JobsSearches WHERE jobsSearchesID = Expression (param 1) Where it has completely removed the SELECT from my SQL statement. Now the only reason I can come up with is that we recently 'UPDATED' our JDBC drivers, but have you guys ever seen anything like this before? Thanks. -- Simon Baynes www.simonbaynes.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
