Search results for query: *

Hi all, Now then - we as a company have had a new piece of software installed that requires VPN access, http access and remote desktop. My MD in his wisdom goes and asks a vendor what type of firewall we need - he recommends cisco. A few days later and I have got a PIX 506e on my desk with a...

Thanks all - I ran secpol.msi as suggested and it turned out that I had omitted to allow the RDC in Terminal Services. I also omitted to let you know that the Server is also a terminal server. Again many thanks Not bad for a software developer!

Hi All I have set up a 2003 Server from scratch with domain controller, DNS and active directory. What I want to do is create a user group who can access the server via RDC using active desktop but not allow them to shut the machine down. I have read thousands of suggestions but can get none...

Not far off... <%Sql = "UPDATE tbl_operators_users SET password = " & spassword & " where oid = " & soperatorcode & " and username = " & susername & " %> If the database field you are inserting into is numerical then use: " & numnamehere & " if the database field you are inserting into is...

Right we have a client database with a directories page - there is a link at the top of the page for companies begining with a perticular letter like so: A | B | C .... and so on. Now I am having trouble with the sql syntax in my query. What I am trying to do is select all the records from the...

I thought as much the problem is that our main db has data impored to it from 2 other apps - both from 3 parties and not operated by myself - so convincing some of the fools here that 'its for the best' would be easier said than done Thanks for the info Ken

Hi all, Our company db is in need of a bit of an overhaul and some incredibly useful person has suggested that it would be good if when an address line is ordered that it ignores the numbers at the start eg 21 Bill Street 21 Ben Street The numbers would be ignored and then ordered by the...

Cheers fellas, The HTML encode works a treat and the file imported into the app without error. MD's muchos impressed and im sorry to say I took all the credit! Now the beta is proven i suppose i best get on and build the real thing. Again thanks Ken ;0) (XML Generator Guru in the making...)

OK I know this sounds a little odd but all will become clear (i hope) The basics of my app are: 1. client database of products 2. select a number of products from db 3. generate xml document from selected products Now some of the products have temperature limitations (thus the º) Now Ive...

Cheers all - tis working like a dream - few little tweaks and I might be allowed to sleep this week!

Hi all What Im after is a little help with some ASP / SQL What I want to do is pull all the records from the database where the company name begins with A when an A is clicked and all the B's when a B is clicked any suggestions Cheers!

ummm top 100 Percent - no idea - ive removed it now and every record (excenpt those containg '1' and any new records have <NULL> in the Mailed column

No out of 32000 records 5028 of them have a '1' in the Mailed Column

Ok peeps here we go This is the code from my sproc SELECT TOP 100 PERCENT Business, COUNT(*) AS BCounter FROM dbo.tblCoreData WHERE (Mailed is null) GROUP BY Business ORDER BY Business What it is supposed to do is Give be a list of all the Business Types (Business) and the...

Hi all, Basically What i have is 2 tables tbl1 - Clients tbl2 - orders Now what I want is all the clients who havent placed an order. Can anyone show me the basics Cheers Ken

Hi all WHat I want to do is allow a user to upload a txt file to the server and then import the contents of the text file (csv format) into the SQL Server - I have already sorted the upload but I am having massive amounts of difficulty passing the values into the SQL server table. I dont really...

str1 = replace(request.form("chk1"),"'","") This replaces the ' with nothing Hope it helps Ken

The application is open to all browers as it will be a fully public website. What I was wanting to do was have a combo box where the user can see an image of what they are selecting - which in this case is a font. Soooo.... if they drop down the combo and got a list of fonts they would see...

Hi all I want to show my users images in a combo box has anyopne got any idea how it can be done in asp? Or if it just cant be done? Cheers ken

Do you really need to upload the image into the database or could you just upload an image to a folder and store the information about the image in the db? If so try aspfileuploader - http://www.15seconds.com/component/pg001158.htm if not then your looking at components... ken ;0)