Hmm. It seems it's working, it just give out false replies all the time. (IE. Axapta which is a databasesystem won't find any data). I would guess this has to do with IIS config or something. We run PHP as CGI. Does anyone now if this affects security/user policies in w2k iis? Will try reconfig to ISAPI to see if it works better. ASP works fine...
-Jørg "Alain Samoun" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I'm having some trouble getting around with COM objects. Is there any way > > that one can list the methods/properties of an instanciated COM object? > Read the doc if available. > > > > Also. I'm having trouble getting an ASP-script to work, so maybe someone > > could help me translate? I've been staring at it for so long that I don't > > see anymore :-) > > You are not the only one ;( , what you need to do to get help: > - Provide your OS and PHP version. > - Test your system with some code that show COM connections are working (See > for example: http://www.phpbuilder.com/columns/alain20001003.php3 > - Provide the VB or ASP code if available, as you did. > - Provide the PHP code that you have tested. > > Now, regarding the ASP code, it seems that it is invoked via a DCOM > connection, DCOM should be enabled when compiling the PHP version that you > are using. You may also want to have a look at the ADODB code from John Lim: > http://php.weblogs.com/com_php > > Alain > > > > > > (And of course, good links appreciated) > > > > -Jørg > > > > --- > > <% > > > > ' > > ' Logon to the Axapta COM interface > > ' > > Set Axapta = Server.CreateObject("AxaptaConnector.Axapta") > > Axapta.Logon "usah", "pass", "level", "" > > > > ' > > ' run Query > > ' > > Set myRecord = Axapta.CreateRecord("CustTable") > > Axapta.ExecuteStmt "select * from %1 where %1.Name == '" & > > Request.Form("Username") & "' && %1.WebPassword == '" & > > Request.Form("Password") & "'",myRecord > > > > ' > > ' Show result > > ' > > if myRecord.Found then > > Session("AccountNum") = myRecord.Field("AccountNum") > > if Request.Form("ID")<>"" then > > Response.Redirect "/public.asp?id=" & Request.Form("PageID") > > else > > Response.Redirect "/public.asp?keyword=memberpage" > > end if > > else > > Response.redirect "/retry.asp?ERR=" & Server.URLEncode("Bad username") > > end if > > > > Axapta.Logoff > > Set Axapta = Nothing > > > > %> > > --- > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]