2. ASPRunnerPro General questions
  3. Error
This topic is locked

Error

 		5/27/2008 09:18:18
ASPRunnerPro General questions
W
 webman author

Downloaded PHPRunner ansd it worked great. Wanted to ASPRunner and am getting this error
Technical information
Error number-2147217900
Error description[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(isnull(City),'',City) + ', ' + iif(isnull(state),'',state)+' '+iif(isnull(Zip)' at line 1
URL /cbps/jobs_view.asp
SQL queryselect `Title`, iif(isnull(City),'',City) + ', ' + iif(isnull(state),'',state)+' '+iif(isnull(Zip),'',Zip) as Location, jobtype.Type as Category From `jobs` left join jobtype on jobtype.ID=jobs.TypeID where `jobs.ID`=1
Solution Contact support team and send a detailed description of what you doing.
J
 		Jane 5/27/2008

Hi,
please publish your application on teh Demo Account and send link to your pages to suuport@xlinesoft.com for investigation.
W
 		webman author 5/27/2008

I'm inside a Department of Energy firewall. Can it be resolved any other way? I'd rather use ASPRunner, but if I have to will use PHPRunner which is working great.
thanks
W
 		webman author 5/28/2008

Please point me to 'Demo Account', don't see it.
J
 		Jane 5/29/2008

Demo Account button is on the last tab in the ASPRunnerPro.