Re: Invalid column name

Article View: pl.comp.lang.vbasic

Article #92457

Back to pl.comp.lang.vbasic Previous Next

#92457

From: Grzegorz Danowski
Date: Fri, 28 Oct 2005 22:25

24 lines
1588 bytes

Użytkownik "lukasz" <lukas-23@o2.pl> napisał w wiadomości 
news:dju263$5jb$1@atlantis.news.tpi.pl...
> 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'.]
>

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

lub (jeśli data nie jest liczbą):

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

GD

Technical Details

Message-ID: <dju8hl$eqf$1@inews.gazeta.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail

References: <dju263$5jb$1@atlantis.news.tpi.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail
From: "Grzegorz Danowski" <gdn__na@serwerze__poczta.onet.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: Invalid column name
Date: Sat, 29 Oct 2005 00:25:56 +0200
Organization: "Portal Gazeta.pl -> http://www.gazeta.pl"
Lines: 26
Message-ID: <dju8hl$eqf$1@inews.gazeta.pl>
References: <dju263$5jb$1@atlantis.news.tpi.pl>
Reply-To: "Grzegorz Danowski" <gdn__na@serwerze__poczta.onet.pl>
NNTP-Posting-Host: ntwklan-62-233-197-214.devs.futuro.pl
Mime-Version: 1.0
X-Trace: inews.gazeta.pl 1130538357 15183 62.233.197.214 (28 Oct 2005 22:25:57 GMT)
X-Complaints-To: usenet@agora.pl
NNTP-Posting-Date: Fri, 28 Oct 2005 22:25:57 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Priority: 3
X-User: grzegorz_danowski
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message