Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

Parameter Query Using Dreamweaver Code

Posted 01 Jun 2004 14:50:27
1
has voted
01 Jun 2004 14:50:27 Darragh Kitt posted:
Hi,
I need to pass two dates as parameters to this query(in an Access Database), Where should I pass them? Or is it possible.

Many thanks.
<%
Dim RS_Spread_Data
Dim RS_Spread_Data_numRows

Set RS_Spread_Data = Server.CreateObject("ADODB.Recordset"
RS_Spread_Data.ActiveConnection = MM_conn_Cross_Reference_STRING
RS_Spread_Data.Source = "SELECT * FROM QRY_TEST"
RS_Spread_Data.CursorType = 0
RS_Spread_Data.CursorLocation = 2
RS_Spread_Data.LockType = 1
RS_Spread_Data.Open()

RS_Spread_Data_numRows = 0
%>

Replies

Replied 01 Jun 2004 16:36:54
01 Jun 2004 16:36:54 Dave Thomas replied:
do not spam your posts across the other forums plz.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Reply to this topic