经典asp疑问请帮帮我 [英] Classic asp doubt please help me

问题描述

我正在使用经典ASP和JavaScript，但出现错误.有人可以帮我吗?

I am using Classic ASP and JavaScript, i m getting an error. Can anybody please help me?

var a="select * from GMA_Time_entry where Time_study_date IS NULL AND Unique_ID='"+Session('Unique_ID')+"";

但是它不能正常工作，也没有显示任何错误.
查询有什么问题吗?
当我在sql server中尝试如下时:

select * from GMA_Time_entry where Time_study_date IS NULL AND Unique_ID=515;

我正在获取o/p.

But it is not working properly and not showing any error.
Is there anything wrong with the query?
When I tried it in sql server like this:

select * from GMA_Time_entry where Time_study_date IS NULL AND Unique_ID=515;

I am getting o/p.

推荐答案

是的，您在=之后有一个额外的''.用这个

Yes, you have an extra '' after =. Use this,

var a="select * from GMA_Time_entry where Time_study_date IS NULL AND Unique_ID=" + Session('Unique_ID');

这篇关于经典asp疑问请帮帮我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！