I managed to solve the previous problem, but have another one.
If the database doesn't have a requested record I want to redirect to a contact page. How do I do this?
Try www.names.co.uk all except the cheapest option support ASP (cheapest with ASP is £89.99 + VAT per annum with a free .co.uk registration) and they have a real technical support helpline with real people! LOL!
I've used their services for years and found it brilliant. On the rare occasion I had to ring tech support I was through quickly and they doubled over backwards in a metaphorical way to help.
Problems with a rewritten subselect query - dBforums::
Rudy's solution is elegant, and I'd actually thought of proposing it. The problem that I've run into is that sometimes you'll have "dirty" data,
http://www.dbforums.com/mysql/989507-problems-rewritten-subselect-query.htmlHOME |
Elliott
Hi Mike,
Yep, it worked. Thanks. Now one more question...
I have uploaded the asp files to my site. In the browser I typed www.#####.com/buying.asp. I was then asked whether I wanted to save or load the file. What am I doing wrong?
Thanks Mike. I will try this and let you know the results (should be OK though).
Depends on how you define "not having a requested record". If your query comes back with an empty recordset its pretty easy.
Enterprise Systems | In Depth: Closing the Ad Hoc Query ::
Jul 9, 2008 To wit: instead of tackling the ad hoc query problem by massaging first have to funnel their queries through the data management group.
http://esj.com/Business_Intelligence/article.aspx?EditorialsID=9034HOME |
It looks like from your previous post you are using Dreamweaver which creates god-awful looking script code. But it would look something like this:
Recordset1.Open()
If Recordset1.EOF AND Recordset1.BOF Then
'Empty Recordset - no results
Response.Redirect "contactpage.asp"
End If
I do not believe it!!!!!
You are correct. I am not one of those who can pick things up quickly. I'm in my forties. I had the first digital watch in my school. It was a Sinclair thingy. Built like Jodgrell Bank.
It's taken me absolutely sodding weeks to write the pages and my host doesn't support it. When asked why, they said it was too much trouble. Name and shame time...
CRAZYHOSTGUY.COM SUCKS
There. I got it off my chest.
Ouch, my first guess is that your web host or your web site, is not configured to host ASP :-(
Hi Mike,
Yep, it worked. Thanks. Now one more question...
I have uploaded the asp files to my site. In the browser I typed www.#####.com/buying.asp. I was then asked whether I wanted to save or load the file. What am I doing wrong?
Thanks for this info. Unfortunately, the one I need is 200 quid. That is a bit too expensive. Especially with the $HK exchange rate.
I will keep looking...
Well looks like his servers are linux probably, so that makes sense.
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
HOME