Thanks Mark. I'd spotted the missing .checked bits and added them in already without any luck.
I'm just trying your solution without joy so far (syntax errors). Think I might be getting confused trying to include your amendment. Any chance you could post the whole code in a oner.
Densely...
I want to approve a user's form (i.e. send if off for processing) if they meet criteria 1 & 2 or they meet criteria 1 & 3 or they meet criteria 1 & 4.
In each case the answers are provided by radio buttons, the first option of which is YES and the second of which is NO.
I'm getting a bit...
Hi,
I've added a static WINS entry of FREDBLOGGS for a machine on our network.
I can now ping FREDBLOGGS, but I can't browse to the machine using START, RUN, \\FREDBLOGGS. I can browse to it via \\XXX.XXX.XXX.XXX (IP address) though.
Why is this?
Thanks,
Jason.
I believe the program contains some code that says "if the user is a member of this NT group then continue, else crash and burn".
Unfortunately I don't know which group it checks for.
Hi,
I have a small .exe file written in an unknown language, and I need to know which global groups can run it. Unfortunately, I have thousands of groups, so it's not very easy to figure.
Anyone have any ideas?
Thanks,
Jason.
So, I've created default value called dbo.blank and set it to ' ' . All NULLS in new rows I enter are replaced by this, but not NULLS that already existed before I created the default value.
How can I force an update of the older rows?
Thanks,
Jason.
Hi,
I need to put the non-breaking space character as the default value for the cells in table if they are left blank, so that my web page displays properly (see the problem at http://crowhurst.dns2go.com/lbdb/samples.asp).
How do I do it? I tried but SQL puts brackets round it, and it...
OK, I think I got it. This is what I need...
SELECT Distinct p.*
FROM dbo.lbplatters p INNER JOIN dbo.lbtracks t on p.plid = t.plid WHERE p.artist LIKE '%MMColParam1%' and (p.title LIKE '%MMColParam2%' OR t.title LIKE '%MMColParam2%') and p.label like '%MMColParam3' and p.year like...
Aaaah, hang on....
I've removed ALL the brackets from your SQL and this now works:
SELECT Distinct p.*
FROM dbo.lbplatters p INNER JOIN dbo.lbtracks t on p.plid = t.plid WHERE p.artist LIKE '%MMColParam1%' and p.title LIKE '%MMColParam2%' OR t.title LIKE '%MMColParam2%' and p.label like...
Vancouverite,
Thanks for the answer. It's almost there, but the brackets don't seem to match up and I can't seem to get them right.
It if search for track "confusion" it now returns the fileds for the LP which contains that track. However, it's not returning the entries for the 2...
Hi,
I'm working on a music discography site. The test version of which can be seen here... http://62.137.131.204/lbdb/search.asp The best way to
see what I'm trying to accomplish is by searching for 'get loose' as a title on the search page (this is the only record in the database that is so...
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.