Recent content by sipps

The actual file stored in the database field is doubling in size. So in Database A, the PDF document is 1Mb. I copy the entire table to Database B, view the same document and it is now 2Mb. Cheers

Hi all, I've got one database with a table which holds a lot of documents in binary format (Image) in SQL 2000. I have used DTS to transfer this table into another database table and when the files are retrieved from this DB, they have doubled in size! Now I have read somewhere that when...

Hi ca8msm, Thanks for your reply. That is a good suggestion. I am having problems getting reference to the child dummy node though. opTreeView.SelectedNodeIndex = zpNodeIndex; The above gets me the parent node to which I have expanded. I need to get the child node which belongs to this...

Hi, I'm currently building a page which has a tree view control. I would like to build the tree on the fly rather than downloading all the data at once as there is a load of data which takes too long to download at once. This is fine as the stored procedures I'm using return a count of any...

Hi all, How can I mirror what a user types into one text box into another text box? I think it uses the onChange event so that as soon as the user starts typing into TextBoxA, TextBoxB shows TextBoxA's value? Thanks sipps

Hey all, I would like to be able to get the name of the server that my ASP pages are on. I need some sort of function to tell me what URL the user has used to access the site. This is because some users access it through an IP address and some through a domain name. The returned server name/IP...

Hi all, I have a strange issue. When entering new records into my table, the auto-id number does not show. When I close the window down and open it again using return all rows, it shows the records and their id numbers. The problem is the ID numbers are incrementing by 2 not 1. I have double...

Hi all, I have installed Apache on Windows XP Pro expecting it to work as other installs have in the past. This is a new machine set up with Windows XP Pro SP1, including IE 6. I installed Apache, and the monitor icon came up ok and says that the service is running. Anytime I open up a...

There's a conference in the next couple of weeks, so I imagine the release will be quite soon.

Sorry sleipnir214, I am unsure what the error is here. This query is only bringing back the product_line records and not the related records of installation or computer. Is there something incorrect with the join queries I am using? SELECT * FROM product LEFT OUTER JOIN product_line ON...

It's strange, I know what I need in a way, but I can't write it! I want to select all the product_line items of product type 1. Some of these line items may be associated with a computer, some may not so I want to show both. I have written an outer join query to show all the computers, with...

Thank you sleipnir214, I shall try that now and see what I come up with. Sorry for not mentioning the category table. Each product is of a certain category, i.e Operating System etc. Thanks again, sipps

Hi all, I am building an internal site which manages our computers/users and what software is currently installed on each system. My query is that I want to show all the copies of one particular piece of software, and whether they are installed on a computer (and which computer!). So I have...

Thank you both. I realise that it is not with the web servers, more with the apps, i.e. how PHP handles sessions compared to ASP. When I use sessions with PHP they are stored on the server in the PHP folder so I do not have to use cookies. ASP however uses cookies, and because the same cookie...

Thanks siberian. Is it right that ASP cookies can only be written once by the same URL on one computer? If I set a session variable in PHP then that is available throughout the life of the browser and cannot be modified by another browser using the same URL. I am not sure what ASP does to...