Recent content by HowardMarks

Hello, Thanks very much for your help. I decided to make life a bit simpler for myself by storing a copy of the key from the listing_options table in each listing_user_options row. This allowed me to dispense with the cross join to the listing_options table and simplifies the structure...

Hiya I know that would be a way to simplify the design, and believe me I would have done it that way if it were possible. The crux is that the system hinges on the ability for an administrator to create an unlimited amount of various fields, each with a type of short text, long text, boolean...

Dear all, hopefully some one can help me with this, i've been banging my head against it all day. My table structure is as follows: listing_options: loption_id, loption_key 1, "title" 2, "maindesc" 3, "mainimage" listing_user_options: lo_listingid, lo_loptionid, lo_value 1343, 1, "This is...

Thanks for you suggestions guys, I will look into making sure this is validated first, and proceed from there. Nick (Webmaster) http://www.npfx.com http://www.artswales.org

Hi guys I have a site at http://www.actiles.co.uk/zenith/ The central portion of text on the home page is contained within a div with overflow:hidden; and any scrolling is dealt with with some javascript. In Mozilla the container div sizes correctly on first load, but in IE6 when the page...

Hi Mark I considered using response.redirect, but I am reluctant to do so as I really want the current viewstate to be preserved when the user switches language, rather than just reloading the page from scratch - e.g. if they have navigated to a certain list or event in a page and wish to view...

Hi guys I have a bi-lingual site utilising a masterpage. On each page I have a usercontrol with a 'change language' button, which when clicked cause a postback, which in turn raises a bubble event to the masterpage. In the bubbled event handler I set the session language variable to reflect the...

Many thanks for your advice Jason. I will go down the route of multiple pages as you suggest. Thanks for mentioning the multiview feature, this is something i hadn't encountered until now. Cheers, Nick Nick (Webmaster) http://www.npfx.com http://www.artswales.org

Hi Chaps I've recently made the transition over to .net from classic ASP, and I'm in the process of rewriting an existing site. I have a fairly complex user admin section where users may add events to a database, edit and delete them etc. In classic asp I would probably have encased all the...

My pleasure, i'm glad you got it sorted. Website looks very nice btw. Nick (Webmaster) http://www.npfx.com http://www.artswales.org

Oops sorry i should have made that line If Not searchItem = uBound(searchArray) rather than searchArray.RecordCount. Too used to using recordsets! Nick (Webmaster) http://www.npfx.com http://www.artswales.org

You need to split the search term up into separate terms and then test for all or 1 of those terms in your sql, e.g. Dim searchArray : searchArray = Split(Request.Form("SearchValue")," ") strSQL = "SELECT * FROM tblGroups WHERE [Active]=true AND (" Dim searchItem For searchItem = 0 to...

Thanks Mark The DataReader looks like just what I need. I will have a play with it. Best wishes Nick Nick (Webmaster) http://www.npfx.com http://www.artswales.org

Dear all Please bear with me as this is a probably a pretty basic question but I'm having trouble getting my head around asp.net 2.0 after years of developing with classic asp. I know that there are loads of automated data collection types such as the grid view and repeater controls, but what...

Hi All We run an events calendar on our website, which I am in the process of revising. It's based around the Arts so its full of things like exhibitions, plays, gallery opening etc. It's always a head scratcher to figure out how best to store and show the information for these events...