Hi,
Thanks so much for your reply.
I have gotten to a stage whereby I can create an instance of the object but cannot execute any of its methods. I keep on getting an 'Bad Variable Type' error.
The object is written in Delphi I think, the method is below:
function Logon(OperatorGroupID...
Hiya
I am trying to execute a COM objects method from T-SQL. I am using sp_OAcreate to create an instance - which is not producing an error.
The Method expects 3 variables, int, string, string. and returns a 1 or 0.
I am referencing it as below..
EXEC @hr = sp_OAMethod @object, 'OLogon'...
Hi
Thanks so much for your reply.
The only reason I need to execute an asp page is because I need to execute a COM object.
Can the object rather be executed via the Sproc sp_oa?
Regards,
Brett
Hi
I have an asp script that I need to execute as part of a SQL stored procedure, passing paramaters in between. Is this possible?
Thank you kindly for any help.
Regards,
Brett
Hi
I have previously been using cdonts and cdosys to send asp based mail - basically looping through a recordset of emails adresses and generating the body of the each email with the results of a query to the db using that email address. Hence each email is dynamically sent and generated. This...
Hi
We are running a intranet fired up by IIS 5.0 (windows 2k)and have encountered a bizarre problem with one of my users. This user only has access to a certain part of the intranet but every time he brings up the appropriate URL - he is prompted for a password BUT his account locks out...
Hi
I want to use a trigger to insert a row into a new table if one particular column (within that row) has been updated.
How do I code the SQL SYNTAX for Insert 'Updated Row into new table' within the body of the trigger?
Thank you kindly for your help.
Brett
Hi
I want to create a GPO for certain users and restrict them from accessing the internet. I have looked through the polocies and can only locate restricting levels of access and IE options but I want to restrict any internet access for this GPO. Can I deny access to the DNS servers maybe...
Hi Jonax
Thanks again for your help.
The unique identifier for these users is userid column, I want to update the AmountOwed and TotalPaid columns as text boxes next to each userid.
The table is in a SQL2000 db, name is ClientPayment.
Cheers
Hi, thank you for your help.
Currently I have a initial screen to choose the user you wish to modify.
Once a user is selected, you enter the user's details in a form as below..
<FORM METHOD = 'GET' ACTION = 'ConfirmChange.asp'>
Enter New value </font><INPUT TYPE = HIDDEN SIZE = '1' NAME =...
Hi
I want to create one form that has an text entry for each record, the user to enter a value for each record in a seperate text box and have one submit button to process an db update for each record.
I am very comfortable doing this for one record but unsure how to do it for many records...
Hi
Can I export a SQL-Driven recordset directly to a excel spreadsheet, without use of a export wizard - i.e. through ASP code?
Thanks in advance for your help,
Regards,
Brett
Hi,
Im looking for an application that will automatically send emails as a result of SQL queries to a database. Ie, what I want to do is write a script that will generate email addresses every few hours through a query and pass those as paramaters to an email application that will email...
Hi,
Im a dba and have not as yet indulged in the use of activex controls. I am now faced with building an front end to query the database and I would like to use the ActiveX calendar control to query over a date range.
I have played around a little but do not really understand how I can...
Hi,
Many thanks for your previous help. I have now come across a string of student names and surnames but I want to cut that to only be names. For example:
name = john doe
I want to run an update to let name = John
How can I do this - look for whitespace and then include everything in the...
Hi,
I have a list of names and I want to run a script that will update the first character to be upper case, I have tried this but get an error:
update students
set substring(name,1,1) = UPPER(substring(name,1,1))
How else can I do this?
Many thanks for your help
Hi
Yesterday afternoon my query analyser crashed and I have since restarted my computer a number of times, re-installed the application and the exe will still not run.
Funny enough, the other SQL tools are running fine - it seems that the processes are firing but the exe is not running the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.