Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

  Return to Index