Recent content by virtualranger

I am running IIS on an XP Pro development workstation. As local user I can publish sites to no problem and view them. However I'm no IIS expert and I need to find out how to add permissions to allow another domain user access to the webserver to view webpages. I've already allowed port 80 on...

Spot on, thanks. It doesn't have to to be cross-browser compatible. Thanks, Jamie

Ok, in our asp/vb.net database app we have a notes field that can sometimes be quite large. I need to display this in a read-only textbox. The text box automatically scrolls vertically if the notes don't fit in the defined window. So far so good, nice and easy. However, the most recent notes...

I use the following query to search for all stored procedures in a db that contain a certain string: SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE 'your search string here' AND ROUTINE_TYPE='PROCEDURE' Thanks, Jamie

You were right, the array was populated but wasn't formed correctly. I needed to change the formation of the array to this: Do Until rsCountry.EOF 'check if the first column item is equal to it's value ' from the previous loop, if not start a new array If last_item <>...

Looked thru the FAQ's and found some useful tips on Dynamic list boxes. Unfortunately my code isn't working. Must be something simple. I know the recordset contents are correct. There is no error when I load the page, the first list box populates correctly but it won't populate the second...

That'll do it! I knew it would be simple. Many thanks. Thanks, Jamie

I've had a look at the FAQ and done a search but can't find what I'm looking for. I've got all my data from an Access Db and can display it in a simple table. My data contains an attribute called developmentID (not unique) and is ordered by that attribute. I would like to diplay my data in...

Excellent, thats sorted it. Thanks very much! Thanks, Jamie

I have a ddl populated with some userID's from a dataset taken from my user table. I have also added the Listitem 'All' manually. When users visit the page I need the DDL selectedindex to default to their own user initials if there is a match, if not it should default to 'All' . The userID...

Many thanks for replies, I was indeed just looking at pivot tables as the solution. Thanks, Jamie

OK, I have a list of data for every sinlge day since 01 May 1961 to present. It displays the date in one column (dd/mm/yyyy) and amount in the second column. This is over 16000 rows of data. Basicaly I need to get the average amount per month, and year, for the whole 45 years. i.e. 1961...

Excellent, I think I understand that, I'll give it a try. Thanks, Jamie

Sorry, you have misunderstood. I know how to do basic export via DTS, thats all fine for the data, but how do I automatically insert the static text insert into the top of the file above the data: #HEADER# EOF:'^' EOR:'~' #DEFINITION# AGENT_REF^DATE^PROPERTY_ID^ADDR1^TOWN^COUNTY^ Ta...

I need to create a .txt file for uploading some of our sql server based data into another comapany's database (non-sql). It's a daily upload so the file creation needs to be automated. The file needs to consist of a header, a definition (detailing the data attributes), and the data itself...