Basically I'm running this bit of code in order to update records in a table, however the code will only update the 1st record and not the full record set. I'm brand new to VBA and I'm very frustrated.
I was thinking maybe a function or a loop to apply code to each record in turn
Please...
I have an ASP application that calls a VB component, requesting a PDF from a back end DOC1 application. The PDF is passed back to the ASP as binary within a variable of type VARIANT.
How can I then display this binary data as a PDF document?
I've used the response object to do this before, but...
I have a problem where a users are submitting a form more than once and this is then sending duplicate messages to my back end system.
Is there a way I can trap and subsequently stop the form being submitted twice ?
P.S I don't want to disable the submit button and they also have a requirement...
I have created a server application in COM+ to run under a specific Domain userID on an W2K applicationserver. I've then installed a very basic VB component into the package that returns a string value.
I then export the package as a proxy client and install the MRSI package on a W2K webserver...
I have to develop a VB Component that reads through a defined XML document and then dynamically build HTML or ASP code which will be splatted into an existing template on the web server. The Component will sit on an APP server so I don't think it will have the IIS capabilities to use the...
I've been tasked with creating a standard ASP function that will validate all input fields for SQL injection attacks from hackers Server Side.
After several hours of browsing it appears the best method is to create a pattern using the Regular Expression object and validate against that.
This...
I've got an application that uses the HTTP_REFERER variable. This application is working on all our current servers but we're currently building a new server for testing and for some reason it doesn't work on it. I've done some debugging and it's the HTTP_REFERER causing the problem.
When I...
We have an old web site hosted on a web server. From a page on that server the user can re-direct to a new application hosted on another web sever. If this server is down then the standard ASP error is dipslayed which isn't very neat.
Can I run a script in the background on a web page that...
I've only recently began using components and have completed one that handles security for a web application. As the number of users will be large I've been told to run the component under MTS. A week later and several books digested I've slapped some code into the component, registered it in a...
My company have decided to implement it's own Web Servers and host our own sites, where before we would use an external company.
They have implemented clustered 3 tier servers.
This caused the alarm bells to ring as I have found articles stating that session variables do not work in this...
The below ASP page should pass a string to a Oracle stored preocdure then using the returned recordset display the data using paging, simple. The IN_SQL string would be built up by a user selection but whilst I'm developing it's hardcoded in the ASP page.
I am getting a syntax error in...
I'm having trouble with a stored procedure. In VB I am setting a passed parameter like this :-
IN_SQL = "SELECT * FROM SUMMARIES WHERE client = 1234 and driver = 'SMITH' "
This is then being sent to a stored procedure which is using this paramater to fill a cursor ref :-
OPEN...
I have a VB com which must take a user input ( ref number )selected on an ASP page .
A Stored Procedure is then executed on an Oracle DB with the ref number as a passed param. The Stored Procedure will then pass back many records back to the VB component.
I am having great trouble with in...
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.