Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '+selObj.options[selObj.selectedIndex].value+' to a column of data type int.
|
| |
The error occurred in C:\Inetpub\DOTTO\Webs\saneinternet.com\SI\saneadmin.cfm: line 47
Called from C:\Inetpub\DOTTO\Webs\saneinternet.com\SI\index.cfm: line 5
Called from C:\Inetpub\DOTTO\Webs\saneinternet.com\SI\saneadmin.cfm: line 47
Called from C:\Inetpub\DOTTO\Webs\saneinternet.com\SI\index.cfm: line 5
|
45 :
46 : <CFQUERY NAME="caller.info" DATASOURCE="#caller.DS#" USERNAME="#caller.DS_USER#" PASSWORD="#caller.DS_PASS#" MaxROws="1">
47 : SELECT * FROM offices WHERE OfficeID = '#caller.urlargs.pageid#' AND SiteID = '#caller.SpanAdminSiteID#' AND LangID = '#caller.SpanAdminLangID#'
48 : </CFQUERY>
49 : <CFQUERY NAME="caller.all" DATASOURCE="#caller.DS#" USERNAME="#caller.DS_USER#" PASSWORD="#caller.DS_PASS#" MaxROws="1">
|
|
| SQL |
SELECT * FROM offices WHERE OfficeID = '+selObj.options[selObj.selectedIndex].value+' AND SiteID = '26' AND LangID = '2'
|
| DATASOURCE |
okmaky |
| VENDORERRORCODE |
245 |
| SQLSTATE |
22018 |
|
|
Please try the following:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.18 |
| Referrer |
|
| Date/Time |
09-May-08 10:25 PM |
|