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...
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...
Thanks to everyone for their advice on this problem. I have now managed to resolve it.
Even though I had actually removed the worm itself, there were still thousands of emails in the queue folder which were getting sent to the badmail folder as soon as the mail server was restarted, making it...
Hi, thanks for your advice. I've run HiJack this and the log is as follows:
Logfile of Trend Micro HijackThis v2.0.0 (BETA)
Scan saved at 09:25:20, on 13/07/2007
Platform: Windows 2000 SP4 (WinNT 5.00.2195)
Boot mode: Normal
Running processes:
C:\WINNT\System32\smss.exe...
Hi Dave
Thanks for your advice, but actually I'm not using Exchange. I only run the SMTP service as a means to send automated emails from a script on my websites.
I think that although a removal script would help a bit in keeping on top of it, the files are getting written at such an...
Hi guys
I wonder if you could help with an issue with my Windows 2000 web server.
I noticed that disk space was being eaten up at an alarming rate, and when I checked there was about 5 gigs of files in the badmail folder. I stopped the smtp service and deleted the files (which took several...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.