if Status = "Active" then
CmdSQL.CommandText = CmdSQL.CommandText&" AND Sony_CusMas.CordLat is not null'"
CmdSQL.CommandText = CmdSQL.CommandText&" AND Sony_CusMas.CordLong is not null'"
Else
CmdSQL.CommandText = CmdSQL.CommandText&" AND Sony_CusMas.CordLat is null'"
CmdSQL.CommandText = CmdSQL.CommandText&" AND Sony_CusMas.CordLong is null'"
End if
Tag : - - - -
Date :
2010-01-11 15:06:25
By :
ไก่ก่า
View :
1668
Reply :
3
No. 1
Guest
ขึ้น error ตัวนี้อ่ะค่ะ invalid column name แต่ว่าคอลัมถูกแล้วน่ะค่ะ
if Status = "Active" then
sSql= sSQL &" AND Sony_CusMas.CordLat is not null'"
sSql= sSQL &" AND Sony_CusMas.CordLong is not null'"
Else
sSql= sSQL &" AND Sony_CusMas.CordLat is null'"
sSql= sSQL &" AND Sony_CusMas.CordLong is null'"
End if
Load balance : Server 04
