interdev_programming thread: Parameterized queries - Win95, Vis. Studio Pro, PWS, Access
Message #1 by "Bill" <wjniemi@a...> on Mon, 5 Feb 2001 11:04:28 -0000
|
|
Bill,
It works OK using ADO. ( I am using SQL Server 7 as the db)
ie. make a connection object in global.asa Data environment then make a
command object of SQL type.
Invoke the sql Builder and put =? in the criteria for field that you want
use
as a parameter. Close this window and reopen the command object and go to
the parameter tab.
hth
Bob
I've been trying to create a parameterized query with no success.
>
> I used the DTC Recordset control with the following SQL statement:
> SELECT Comment FROM VoterAlertIssues WHERE Issue = ?
>
> According to the Microsoft Programmer's Guide, you should be able to
click
> the Parameters tab and see a "list of parameters specified for your
> query". However, there's nothing in the box.
>
> Any help will be appreciated.
>
> Thanks,
>
> Bill Niemi
> Iowa, USA
|