
March 9th, 2004, 04:02 AM
|
|
Registered User
|
|
Join Date: Oct 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
ActiveX control & passing a SQL string from asp\VBScript
hi
I've been working on a project were by i've created a graph program in VB (an activeX control; ocx) that is dynamically populated by data from an ASP page.
At present the asp page creates a text file in which it writes a SQL string that is then read by the activex control which in turn displays the values of that string on the line graph.
This all works, but i want the string passed by the asp page to the page that contains the activex control with out the use of the text file. (i.e. i need a way to pass the sql string directly into my activex control)
I've used a hiddenfield to pass the sql string from my asp page to the page that contains the activex graph:
<%
'activeX web page
Dim savedSQL
savedSQL = Request.Form("hiddenField")
%>
<OBJECT ID="activeXCGraph" CLASSID="CLSID:3ac4c6d2-e43e-48c5-af6c-4479cf929799"
CODEBASE="activeXGProject.ocx">
</OBJECT>
But the problem i have is that i need a way to pass 'savedSQL' string into my activeX control were it can be used to make the graph.
Any help appreciated
Thanks
Palvinder Singh
|