Search results for query: *

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...

Thanks John Any column may be updated, I only want the trigger to fire if column A is updated though..

Great! Thanks John. Works perfectly. What if I want to only insert that row if column A has been updated? Where do I add this to the insert statement?

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 This worked like a charm! Thank you so much for your help. :)

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...