Error Executing Database Query

[jebry]

Hi!

I am getting this error after entering a survey program when I try to update the database with the information from the web page. Here is the full error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC driver for Oracle]Error in row 1

The error occurred in D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 17
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 14
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 4
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 1
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 17
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 14
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 4
Called from D:\web\prodroot\Gradschool\survey\doc\survey.cfm: line 1

15 : <cfset students_id = form.id>
16 : <cfquery datasource="GRADSCHOOL" name="temp_info">
17 : select * from survey.students where students_id = '#students_id#'
18 : </cfquery>
19 : <cfset info = temp_info>



--------------------------------------------------------------------------------

SQL select * from survey.students where students_id = '1620'
DATASOURCE GRADSCHOOL
SQLSTATE 01S01

We have CF6 standard version and the back end is Oracle 9i.

Thanks for any help you can provide!



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[TruthInSatire]

if students_id is numeric remove the single quotes around '1620'

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[klaforce]

Also make sure the owner of students is survey.


Keith

http://www.clemson.edu/~davidla

The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

 

[jebry]

Hi again!

I have some more information now. First, thanks to TruthinSatire for the quote catch. It didn't solve this problem but it will avoid one later!

What we are doing is sending out emails to students with an URL that brings them to our survey with their ID. When we first get into the survey it asks for demographic information and then that is stored in the students table. That part worked fine. When we tried to retrieve that information later we got the error I originally posted. So we fixed the problem discoverd by TruthinSatire and started over. When a student returns to the survey, which is what I did, survey is supposed to display the demographic information if there is any (there was now for me) and so, I got the error on the first page time. The db admin looked in the table and we know that the information is there so the program stored it fine, but for some reason, it won't retrieve it.

Have you seen anything like this?




Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[TruthInSatire]

klaforc brings up a good point you say "survey.students" that says the owner of the students table is "survey" often times you'll see ownerName.tableName.fieldName

if the owner isn't required you can just use tableName.

select * from students where students_id = #students_id#

ask your DBA who the owner is if you're not sure.


We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.