Invalid column name

Article View: pl.comp.lang.vbasic

Article #92455

Back to pl.comp.lang.vbasic Previous Next

#92455

From: lukasz
Date: Fri, 28 Oct 2005 20:37

21 lines
1220 bytes

witam

mam pytanie jak zawęzić wyszukiwanie (ASP.NET) w tabeli do wartości 
określonej jako tmp ?



Dim CommandText As String = "select TrN_Data2, data from rasp where data = 
tmp."



wychodzi mi taki błąd



[SqlException: Invalid column name 'tmp'.]



pozdrawiam !

Technical Details

Message-ID: <dju263$5jb$1@atlantis.news.tpi.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: "lukasz" <lukas-23@o2.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Invalid column name
Date: Fri, 28 Oct 2005 22:37:22 +0200
Organization: tp.internet - http://www.tpi.pl/
Lines: 23
Message-ID: <dju263$5jb$1@atlantis.news.tpi.pl>
NNTP-Posting-Host: cko33.neoplus.adsl.tpnet.pl
X-Trace: atlantis.news.tpi.pl 1130531843 5739 83.31.90.33 (28 Oct 2005 20:37:23 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Fri, 28 Oct 2005 20:37:23 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit