Recent content by Craftor

Hi all, I have been asked to investigate whether there is any automated tool to convert MS Access applications into .NET web applications with a SQL backend. I've taken a look at 2 currently on the market - DBForms and Microtools Access Whiz. Both of them handled the data conversion fine but...

Hi all, On my TreeView, the javascript code to expand or collapse the menu items is displaying in the status bar when the user hovers over those images e.g. javascript:TreeView_ToggleNode(ctl00_leftNavigationTreeview_Data... Is there any way to prevent this from displaying? It looks...

Thanks for this jmeckley. Craftor 8-)

Hi all, I'd just like to get your thoughts on what would be faster overall - caching values from the web.config file, or just reading them as required. Caching would obviously add overhead to the server memory but I'm curious as to whether it would give any significant performance gains...

Thanks that's the sort of thing I was looking for! Craftor 8-)

Hi all, Another question on getting a record for the most recent date... I have a list of prices in a table and I need to get the most recent price for a specified item. I've got the following query which correctly brings back the most recent price: select priceID, price_date, price_value...

Hi all, I'm passing a list of values to a stored procedure using an XML parameter. The stored procedure is used to search a table for matching values so this list can contain one or many values, or could be NULL to indicate all values should be returned. How can I phrase my query to cope...

Thank you for both of your responses. I ended up removing the dynamic SQL and using the ISNULL statement to see whether the parameter passed in is null and, if not, to use that parameter. Thanks as always Craftor 8-)

Hi everybody, I'm using dynamic SQL in a stored procedure to build up a query that can have a variety of WHERE clauses depending on what parameters are passed into the stored procedure. One of my parameters (a DATETIME) seems to be causing an error: Conversion failed when converting datetime...

Hi, Thanks for your responses. bborissov's suggestion seems to be the best as it takes my calculated values into account. Thanks as always Craftor 8-)

Hi everyone, I'm currently doing a calculation in a stored procedure and I need to check if all of my calculated values are zero. I've allocated the values to variables as they are used in various places during the calculations - aside from a massive IF statement, is there an elegant way to...

Thanks for both your responses - Vragabond I don't think the span that's causing the break - it just sets the color of the elements in it : .toptoolbar { color: #999999; } Lowet - I tried applying the style elements to the form tag but still got the line break so I've just included all of the...

Hi all, I'm encountering a horrible problem with Netscape 7.0 with a line break occurring before a <form> tag. I've got the following HTML: <span class="toptoolbar"> <a href="/search/sitemap.aspx" class="toollink">Site map</a> | <a href="/contact/default.aspx" class="toollink">Contact us</a>...

Thank you tsuji that solved the problem! Craftor 8-)

Hi all, Here is a snippet from my XSL file: <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="html" omit-xml-declaration="yes"/> <xsl:template match="mytemplate" xml:space="preserve"> <div>...