gavinjd
Posts: 4
|
Posted: 01/21/2004, 12:45 PM |
|
Hi,
I am new to CCS having spent a lot of time previously in Access.
Currently I have some access applications that I call from another program using vbscript as follows:
Option Explicit
Main
Private Sub Main
Dim appAccess, strOrder, strCustomer
StrOrder = ORDER_ID
StrCustomer = CUSTOMER_ID
Set appAccess = CreateObject("Access.Application.10")
appAccess.Visible = True
appAccess.OpenCurrentDatabase "Path to MDB", False
appAccess.Run "Do_the_job", StrOrder, StrCustomer
Set appAccess = Nothing
End Sub
This launches the access application and passes some variables through to it from the native application (Order ID and Customer ID) so that I can then ue those within access for queries etc.
My question is how I would accomplish the same sort of thing in CCS? There's no application to launch so to speak but I'm assuming I can still achieve the same results?
Thanks
Gavin
|
|
|
Edd
Posts: 547
|
Posted: 01/21/2004, 1:26 PM |
|
Gavin,
Are you trying to launch an Application at the Server OR Client. Or are you talking about calling a web page and passing parameters?
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
peterr
Posts: 5971
|
Posted: 01/21/2004, 2:58 PM |
|
Gavin,
Edd asked key question and probably you should answer it first.
Here are some comments though about the server-side VBScript:
CCS generates standard VBScript, therefore if you put any VBScript anywhere in CCS (usually in events) then it should work. You'd first need to decide where/when this script should be launched, then add the above VBScript code to the appropriate event. For example in the Page "After Initialize" event to launch it when a page is loaded, or in the "After Insert" event of a record to launch it when a record is inserted into the database, etc.
Another question here, however, may be if this VBScript code will work in Web applications. VBScript has different security restrictions when run via the browser (client) versus Web application (server) versus desktop application (such as HTA - HTML Application). Therefore you may need to simply test it and see if it will work OK in your case.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
gavinjd
Posts: 4
|
Posted: 01/21/2004, 3:31 PM |
|
Yes, I want to launch a web page and pass parameters.
Gav
Quote Edd:
Gavin,
Are you trying to launch an Application at the Server OR Client. Or are you talking about calling a web page and passing parameters?
|
|
|
BlinkyBill
Posts: 86
|
Posted: 01/21/2004, 8:39 PM |
|
Quote gavinjd:
Yes, I want to launch a web page and pass parameters.
Gav
here you go:
http://www.yoursite.com.au/yourpage.asp?YourParam1=0&YourParam2=Test
now you would like to call this page from within VBSCRIPT, look up the XMLHTTP object.
Just google XMLHTTP and all will be revealed.
|
|
|
peterr
Posts: 5971
|
Posted: 01/21/2004, 11:45 PM |
|
Gavin,
I'm still not sure if you want to launch the application on the client (browser) or the server. Should the Web page launch your application on the server, or on the user's computer?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|