2. ASPRunnerPro General questions
  3. Cannot retrive columns information.
This topic is locked

Cannot retrive columns information.

 		2/18/2004 5:45:24 AM
ASPRunnerPro General questions
L
 llinos author

HI
Whenever I try and modify the SQL query within the ASP runner I get the following error message:
Cannot retrieve columns information. PLease modify SQL query and try again.
See example of code below:
select [LA_name],

[Form_Name],

[Item_name],

[total]

From [tblcdat_test]

where [LA_name] = "isle of anglesey"
I can't work out why this is happening - could it be a problem at my end rather than with the ASP runner?
Please help!
Thanks
Llinos
501008 2/18/2004

where [LA_name] = "isle of anglesey"
Should be:
where [LA_name] = 'isle of anglesey'
It could be hung up on the double quotes and thinking that your SQL statement is finished.
Hope this helped,

Bandit
L
 		llinos author 2/23/2004

Thanks. It worked!