
September 13th, 2004, 04:55 AM
|
|
Contributing User
|
|
Join Date: Aug 2004
Posts: 52
Time spent in forums: 8 h 1 m 11 sec
Reputation Power: 5
|
|
Qn on SQL Query
Is it possible to put another query statement? eg. an Insert statement?
Code:
<%@ Language=VBScript %>
<%Response.Buffer=True%>
<!--#include file="setting.asp" -->
<%
Dim Conn
OpenConnection Conn
Dim sqlQuery
Dim rsQuery
Dim i
Set rsQuery = Server.CreateObject("ADODB.Recordset")
i = Request.QueryString("id")
sqlQuery=""
sqlQuery="SELECT cust_id from ol_answer Where survey_taken='Y'"
rsQuery.Open sqlQuery,Conn
IF rsQuery("cust_id") = Request.QueryString("id")Then
Response.Redirect "process_result.asp"
else
Response.Redirect "survey.asp"
End If
CloseConnection Conn
%>
|