Hi
I am doing a query against a relatively large table. The basic query is as follows:
select aud.record_id, aud.auditdatetime, seqno,
substring(cast(aud.oldrecord as varchar(max)), (dbo.fnNthIndex(aud.oldrecord,'|',8) + 6), 4),
substring(cast(aud.newrecord as varchar(max))...
Hi
We have developed an application which uses java, spring 4.0.3, jsf and primefaces 5, running on Tomcat 7.0.50. We need to authenticate the user without a login form (i.e. it will pick the Windows user ID and compare that to our access management database). Basically we tried to set up...
Hi
I am trying to dynamically retrieve my server name and then, from that, run a statement which will vary depending on the server name that is returned. I can obtain the server name dynamically but am unable to pass it to my IF statement; regardless of everything, @srvName in my IF statement...
Hi
We are doing an inhouse java development. We are invoking Excel and are trying to insert an image into the footer. We have tried various libraries and have considered using .NET code adapted to VB Script but have not had any luck. Has anyone else encountered this problem and is their a...
Hi
At work I am on Outlook 2003 connected to Exchange 5.5. When I do a Reply To All on an e-mail received from outside the company it puts me in the To list; when I Reply To All on internal e-mails all works fine.
I've checked the web and all ideas revolve around people with multiple e-mail...
Hi Guys. I am trying to update a record in a table which needs to be found using 2 fields (i.e. WHERE xxx = qaz AND zzz=456). When I am matching on 1 field only it finds records but where I try to match on the 2 fields it fails to match. My code is as follows...
Hi Guys
I have a data load programme which reads data in from a CSV file. It then selects a record from the database and updates that database record accordingly. The sql SELECT statement is generating an error when I introduce a WHERE clause; the WHERE clause is comapring 2 database fields...
Hi Guys
I have an application that was working perfectly until last night. All of a sudden, it has stopped and I am getting the following error:
Active Server Pages error 'ASP 0241'
CreateObject Exception
/bman/main.asp
The CreateObject of '(null)' caused exception C0000005.
Server object...
Hi Guys. I have an application in ASP which has a text box into which users can enter whatever they wish. As part of that input, I'd like to be able to automatically convert certain text to hyperlinks automatically (e.g. www.bbc.co.uk). Does anyone know how I can do this? Thanks.
Hi. I am trying to re-use a laptop and have Windows XP Professional SP2 installed. When I go to map a drive and ask to use a different name, in the Connect As box I get loads of user names displayed. How can I get rid of the ones I don't want - I don't want to have to re-install Windows.
Hi. We have an application that we developed in Progress 9.0B and used Smart Objects. For various reasons, we need to ugrade the Progress version to 9.1C or later. When we try 9.1C it compiles but when we run it we get the following error:
User-defined function 'setDataColumns' invoked...
Hi
I am supposed to be working on a server where the users have lost the root password. It is SCO 5.0.5. The server is a ML370 with a 642 controller. They have an Emergency boot floppy from another machine with the same version of O/S but different controller so we can't mount the drive to...
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.