Hi Gvee, thanks for the reply.
I've been away from this topic in the last few days due to management wanting somethiing else done, but im now back on with this.
I have checked all files in my project, but the only time "sSQL" is declared is in the comms.asp page, like so:
Code:
<%
Dim conn, oRS, oDB, sSQL
Function OpenDB()
conn = Application("CONN_STRING")
Set oDB = Server.CreateObject("ADODB.Connection")
oDB.Open(conn)
End Function
Function CloseDB()
oDB.Close
SET oDB = nothing
End Function
%>
And the only time the variable sSQL is set is when its in the code for example:
Code:
<%
sSQL = "exec spGetStores"
SET oRS = oDB.Execute(sSQL)
response.Write iStoreID & "-"
If Not oRS.EOF Then
While Not oRS.EOF
%>
This is prominent throughout the code in different pages, for instance:
Code:
Sub UpdateStoreRow()
sSQL = "EXEC spUpdateStore " & iStoreID & "," & iStoreNumber & ",'" & sStoreName & "'"
oDB.execute(sSQL)
End Sub
Hope this helps?
please shout if you need more.
Kind regards
MG
dBforums
>
Is this possible / how can it be done?
09-07-09, 04:28
Linear Mode
