SQL Statement problem

Can someone please tell me what is wrong with my SQL below..I think I am missing a quote somewhere...

"select distinct itype from TR_data_and_history where stationname ='" & StationNameString & " and highkv ='" & VoltageString & "' "
0
iakar123
12/19/2003 3:19:41 PM
asp.net.object-datasource 16182 articles. 0 followers. Follow

2 Replies
360 Views

Similar Articles

[PageSpeed] 8

StationNameString single quotes are not ended
Sushila Bowalekar Patel
Visual ASP/ASP.NET MVP
http://weblogs.asp.net/sushilasb
0
SushilaSB
12/19/2003 3:23:04 PM
Thank you..that was the problem.

Final statement =
"select distinct itype from TR_data_and_history where stationname ='" & StationNameString & "' and highkv ='" & VoltageString & "' "
0
iakar123
12/19/2003 3:55:22 PM
Reply: